Problems with database when moving hosts

[fut]

I am having some problems with my database after moving over to a new host. When someoen tries to make a nwe account, I see the name on the admin backend but do not see the xdate created,

 

then when clicking on the name to view details,. there is nothing.

 

I get these two errors at the top of that page:

 

Warning: reset(): Passed variable is not an array or object in /home/crazyj61/public_html/admin/includes/classes/object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in /home/crazyj61/public_html/admin/includes/classes/object_info.php on line 18

 

 

Also, orders are not registering at all.

 

Anyone know what to do?

[fut]

could it be the root to my public_html folder is different?

 

if so, how would i change this? or would i have to go through every file in OSCommerce and change the root?

[fut]

I've deemed that idea wrong, anyone have any ideas?

[FalseDawn]

How did you backup and restore the database? It sounds like some data and/or autoincrement columns may not have been copied correctly.

[fut]

I uploaded the full backup through SmartFTP and let my hosting company extract it.

 

I tried re-uploading my store.sql file seperately but I am still faced with the same problem.

[Guest]

once u go to a new host, you have to modify your configure.php files to match the new host

[fut]

Hi Guys,

 

Thanks for the help. I've been looking at both configure.php files and boths eem to be correct for my new host.

 

The path to my catalog folder is the same, I have the same username too.

 

What's weird is that somethings are entered into the database correctly (When creating a new account, I see the name of the account created) but most things don't work, (date, all details aren't saved, orders aren't saved - etc)

 

Is there anywhere else where things should be changed that have connections to my database?

[fut]

Anyone?

[FalseDawn]

You are not going to get a solution to your problem here, since there are so many things that it could be. All you will get is speculation and possibilities.

 

Personally, I still think that you screwed up the database backup and restore somehow.

[fut]

You are not going to get a solution to your problem here, since there are so many things that it could be. All you will get is speculation and possibilities.

 

Personally, I still think that you screwed up the database backup and restore somehow.

<{POST_SNAPBACK}>

 

I completely understand. We tried uploading the database again this time slicing it to prevent any data loss but we are still faced with the same problem.

[AlanR]

If you haven't already tried this I'd set the FS path explicitly

 

define('DIR_FS_ADMIN', '/home/crazyj61/public_html/admin/'); (and double check that path)

 

The default:

 

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

 

works well on most servers but not on all. I've seen a lot of mysterious problems cleared up when that path is set explicitly throughout, both in catalog and admin.

 

assuming your store is in catalog the catalog path in the catalog/includes/configure.php would be

 

define('DIR_FS_CATALOG', '/home/crazyj61/public_html/catalog/');

[fut]

If you haven't already tried this I'd set the FS path explicitly

 

define('DIR_FS_ADMIN', '/home/crazyj61/public_html/admin/'); (and double check that path)

 

The default:

 

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

 

works well on most servers but not on all. I've seen a lot of mysterious problems cleared up when that path is set explicitly throughout, both in catalog and admin.

 

assuming your store is in catalog the catalog path in the catalog/includes/configure.php would be

 

define('DIR_FS_CATALOG', '/home/crazyj61/public_html/catalog/');

<{POST_SNAPBACK}>

 

Sadly, yes the path is already changed and i checked with my new host and the path is the same

 

 

Another error I receive on the customer end is when someone tries to create an account I get this error:

 

0 -

 

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('0', '0', now())

 

[TEP STOP]

 

 

 

the mysql version of my old host is 4.0.25-standard-log and the vers. of my new one is 4.0.24-standard-log

 

That probably doesn't mean anything, but at this point i'm looking for anything! that would make this not work on one host but work on the other.

[fut]

Alright well I ggot someone to figure out the problem for me and he says that my host for some odd reason does not allow

 

mysql_insert and now() function to work.

 

Has anyone heard of this malarky?

[fut]

hmm, my host knows nothing of this

[kev2me]

I was having the same exact problem with my store. I searched and found this post that seemed to help me out:

 

http://www.oscommerce.com/forums/index.php?sho...ndpost&p=663862

 

Hopefully that'll help you out, too.