Can't Create Account

[bethbud]

I'm getting this error when creating account from guest cart:

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /mnt/w0801/d37/s07/b00e48fc/www/PJBOUTIQUE/catalog/includes/functions/database.php on line 114

Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0801/d37/s07/b00e48fc/www/PJBOUTIQUE/catalog/includes/functions/database.php:114) in /mnt/w0801/d37/s07/b00e48fc/www/PJBOUTIQUE/catalog/includes/functions/general.php on line 34

Also I found a similar thread here in the forum but couldn't post there because the thread was 'CLOSED'.

Thanks for any help!

UPDATE: Actually looks like it is creating the account but that's not going to make much difference when my customers see that error page. Why is the error appearing? How to fix?

[michael_s]

Can't reproduce the error on a clean install, so how about you give a step by step as to what you are doing leading up to the error and what exactly you do to get the error.

[bethbud]

The error is appearing when going through the steps a regular customer would to create an account in the shop. I was testing the shop- using it as a regular customer would.

Some changes I've made since clean install:
*changed admin folder name
*limited htaccess to my own IP address

[michael_s]

Link to the site so I can test? It is not a problem with the osCmax package, it is specific to your installation.

[pgmarshall]

Line 114 of database.php is:

 
    function tep_db_insert_id($link = 'db_link') {
    global $$link;
    return mysql_insert_id($$link);
  }

So I strongly suspect you have a database setup issue.

Regards,

[michael_s]

You have 2 options:

1. Turn of warnings to the screen (only go to logfile, which is what you should have on production sites).

2. Apply this fix: r221 - oscmax2 - Project Hosting on Google Code

[bethbud]

I don't understand. Sorry, I have very limited knowledge of all this.
If I've only installed the program and made the suggested security changes, why would this cause so many problems?

1. Turn of warnings to the screen (only go to logfile, which is what you should have on production sites).

Where do I do this? What is 'production sites?

Why is my site totally down now? I'm getting this on the index page:
Fatal error: Call to a member function add_current_page() on a non-object in /mnt/w0801/d37/s07/b00e48fc/www/PJBOUTIQUE/catalog/includes/application_top.php on line 350

[pgmarshall]

bethbud,

Simply open the file shown in the bugtraker ...

ie. catalog/includes/functions/database.php

And edit the line shown in the bugtraker ... ie.

Replace

 return mysql_insert_id($$link);

With

return mysql_insert_id();

At line 114.

Regards,