There seems to be a problem connecting to our database

Hi,
I thought I had this sorted then this hapened...

I have a current website and I have a zencart shop on it all working great for a few years now.

I have purchased another domain from my web host and installed zencart onto it. now my original website is stating that it is offline... https://www.craftjam.co.uk

why would it take my website offline? Is it to do with databases?

Thank you
Amy

 There seems to be a problem connecting to our database

This means the database credentials in your configure.php files are incorrect.

oh ok, i had not touched anything on that particular site at all.

Should i just use filezilla to re upload some backup files?

thnak you
amy

Think I may have sorted it. I think I have possibly changed the password for the wrong database...

Ok,
That all got fixed however now on my new site giftsjam.co.uk I get this message.. WARNING: An Error occurred, please refresh the page and try again.

I have checked both config files and they match all logins on the database.

Is this still a database issue?

Thank you
Amy

rainbow_pixie_star:

Ok,
That all got fixed however now on my new site giftsjam.co.uk I get this message.. WARNING: An Error occurred, please refresh the page and try again.

I have checked both config files and they match all logins on the database.

Is this still a database issue?

Thank you
Amy

Not necessarily, but you should now have at least one error log in your cache directory (assuming you are actually using ZC 1.5.0)

well the most recent bug says...
[02-Mar-2016 10:04:05 America/Denver] PHP Fatal error: 1146:Table 'cr******_gi*******.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /home3/cr******/public_html/gi******/includes/classes/db/mysql/query_factory.php on line 101
This is the most recent debug log.

rainbow_pixie_star:

well the most recent bug says...
[02-Mar-2016 10:04:05 America/Denver] PHP Fatal error: 1146:Table 'cr******_gi*******.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /home3/cr******/public_html/gi******/includes/classes/db/mysql/query_factory.php on line 101
This is the most recent debug log.

Yup, a database issue.

Using trusty phpmyadmin, take a look at the database that is associated with this store (old store right?) Verify that there are tables listed, then assuming that there are only about 97 tables, identify the full name of the first few tables.

Hi,
Old site fixed, this is an error with my new one...

SO I have gone into PHPmyadmin and there are no tables at all for the new site.

rainbow_pixie_star:

Hi,
Old site fixed, this is an error with my new one...

SO I have gone into PHPmyadmin and there are no tables at all for the new site.

That's actually a good thing based on the desired result that was posted in another thread. Need to now import your old store's database to this new store that is supposed to be the same version as the previous store.

This explains the whole process:
http://www.zen-cart.com/content.php?142-i-want-to-move-my-zen-cart-installation-to-another-host-or-a-different-server

As far as I understand, I have done all that.
I dont know why I still get this error...WARNING: An Error occurred, please refresh the page and try again.

rainbow_pixie_star:

As far as I understand, I have done all that.
I dont know why I still get this error...WARNING: An Error occurred, please refresh the page and try again.

The understanding comes from the log file generated by that error being caused. Back to the cache directory.

Also, admin wont let me knog in. I have done new password request and created new and it wtill wont let me in.
Is that related to the issue also?

I will look back at the log.

Do you think maybe I should just re install zencart! Just in case something didnt work properly?

Thanks
A

utf8 not supported! So I assume I have clicked the latin option when installing. I did it totally wrong didnt I?

rainbow_pixie_star:

utf8 not supported! So I assume I have clicked the latin option when installing. I did it totally wrong didnt I?

Okay, so as it stands, your new site has new configure.php files but all of the same other files from your old site.
Your new database has everything that your old database has.

Am I correct so far?

If that is the case, then other than the file paths, the HTTP... Related fields and the DB_ stuff if you either post your old and new includes/configure.php files or compare the two and change just the few remaining differences, should be good to go. Any other "errors" would be related to files not fully making it to the new server location intact.

Hi,
Sorry for the late reply, been working on it all day and night! Sorte it all and made it latin1 like my other site.

Everything seems fine until I go to categories/ products to list items and I have the error message...
WARNING: An Error occurred, please refresh the page and try again.
There is no button to create my caregories or to add a product button.
Will keep looking but so far this is the only place I see the error.

Do you know what this refers to
Thanks
A

rainbow_pixie_star:

Hi,
Sorry for the late reply, been working on it all day and night! Sorte it all and made it latin1 like my other site.

Everything seems fine until I go to categories/ products to list items and I have the error message...
WARNING: An Error occurred, please refresh the page and try again.
There is no button to create my caregories or to add a product button.
Will keep looking but so far this is the only place I see the error.

Do you know what this refers to
Thanks
A

Same response: cache directory. Error log. Contents? Knowing that a problem occurred is one part, knowing what the error is (as logged) guides to the solution.

See: http://www.zen-cart.com/content.php?124-blank-page

K, thought i sorted it!
Just looking through logs now.

THanks
A

Is this anything to do with it?

[29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111 [29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111
[29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111 [29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111
[29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111 [29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111
[29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111 [29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111
[29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111 [29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111
[29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111 [29-Jun-2015 13:58:46 America/Denver] PHP Warning: htmlspecialchars(): charset utf8' not supported, assuming utf-8 in /home3/cr******/public_html/includes/modules/pages/shopping_cart/header_php.php on line 111

It mentions cart but not sure how it can relate to adding products.

Have quite a few files in there an the ones I looked at look like a similar error