Hitting a wall with installation : blank screen

[lhungil]

Looks like the server has XCACHE installed. Replace the original "/zc_install/index.php" from Zen Cart 1.5.4.

Then (based on the output from phpinfo) open up "/zc_install/index.php" and change the following lines.

FROM:

if (function_exists('apc_clear_cache')) @apc_clear_cache();
//XCACHE
if (function_exists('xcache_clear_cache')) @xcache_clear_cache();
//EA

TO:

if (function_exists('apc_clear_cache')) @apc_clear_cache();
//XCACHE
if (function_exists('xcache_clear_cache')) {
  @ini_set('xcache.cacher', 'OFF');
}
//EA

And try the installation again with the changes above.

[Northfur]

That line change seemed to work, Thanks! Now to start the install.

[lhungil]

Awesome. Let us know how the install and upgrade goes :)


It may be useful for future reference to know what error was being thrown by "xcache_clear_cache()". If you find some time (this will bring back the blank page error), can you try running the original Zen Cart 1.5.4 code with the "@" removed from the front of that function call? And then providing any error message shown (or debug log)?

//XCACHE
if (function_exists('xcache_clear_cache')) xcache_clear_cache();
//EA

[Northfur]

Ok, so I'm hitting the next speedbump and could use some help.

I've installed Zencart 1.5.4 successfully, it's there, admin works, cart works, database works.

Next step is importing my old database from 1.3.8a

I've exported the old database and included these attributes:
Add DROP TABLE
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

Since in my earlier attempts I ran across the error: #1050 - Table 'address_book' already exists and found the above solution in another thread.

With a long chain involving my host doing the imports since I couldn't get anything to import through phpmyadmin, they managed to import the old database into the new zencart database and didn't report any errors.

When going to admin, there's a zencart error about problems connecting to database, I think this is expected since nothing has been upgraded yet.

Then the wall hits.
I try running zc_install again and the database upgrade option isn't coming up? What step should it come up?
The old and new DB's both have the same prefixes, do they also need the same name as well?

So if anyone can point me in the right direction, it would help alot.

[Northfur]

Warning when I enter the admin: WARNING: An Error occurred, please refresh the page and try again.


Found this in the log about when I try to enter the admin:

[07-Jan-2015 11:05:43 America/Toronto] PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'northfur_zencart'@'localhost' (using password: YES) in /home/northfur/public_html/includes/classes/db/mysql/query_factory.php on line 62

[mc12345678]

Warning when I enter the admin: WARNING: An Error occurred, please refresh the page and try again.


Found this in the log about when I try to enter the admin:

[07-Jan-2015 11:05:43 America/Toronto] PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'northfur_zencart'@'localhost' (using password: YES) in /home/northfur/public_html/includes/classes/db/mysql/query_factory.php on line 62

Another user ran across this error yesterday... Don't/didn't by chance have the phpBB option turned on in the old(er) store did you?

But, to go further, because no additional helpful information was provided in the error log, suggest installing lat9s myDebug backtrace: http://www.zen-cart.com/downloads.php?do=file&id=1879

then, force the error again and check the log for results.

[mc12345678]

Ok, so I'm hitting the next speedbump and could use some help.

I've installed Zencart 1.5.4 successfully, it's there, admin works, cart works, database works.

Next step is importing my old database from 1.3.8a

I've exported the old database and included these attributes:
Add DROP TABLE
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

Since in my earlier attempts I ran across the error: #1050 - Table 'address_book' already exists and found the above solution in another thread.

With a long chain involving my host doing the imports since I couldn't get anything to import through phpmyadmin, they managed to import the old database into the new zencart database and didn't report any errors.

When going to admin, there's a zencart error about problems connecting to database, I think this is expected since nothing has been upgraded yet.

Then the wall hits.
I try running zc_install again and the database upgrade option isn't coming up? What step should it come up?
The old and new DB's both have the same prefixes, do they also need the same name as well?

So if anyone can point me in the right direction, it would help alot.

This error is not expected... A database connection error is never considered a normal response in an upgrade.

[Northfur]

I think it's resolved now....

My host changed the password on my database when they imported the tables.
I went through the database upgrade steps and it seems to be working with both the admin and front end, now to install modules.

[mc12345678]

I think it's resolved now....

My host changed the password on my database when they imported the tables.
I went through the database upgrade steps and it seems to be working with both the admin and front end, now to install modules.

That was the next thought based on the error including using password: YES and a feeling based on the number of hands that have been involved to get through this upgrade.

Congrats, you're almost there!

[DrByte]

Given all the difficulties you've had with importing the database, I'm inclined to ask: who's the hosting company?
Don't they provide standard tools like phpMyAdmin to manage database data?