How do I troubleshoot the MySQL Database?

[Tim Romero]

I think my database might be messed up, and I would like to fix it. Im not too sure how to navigate around in phpmyadmin, or which setting to change that might need to be changed. Is there an easy way to locate problems within the database? Maybe a way to compare settings against a fresh installed osc database? Any suggestions would be really helpful. THanks!!

[♥FWR Media]

I think my database might be messed up, and I would like to fix it. Im not too sure how to navigate around in phpmyadmin, or which setting to change that might need to be changed. Is there an easy way to locate problems within the database? Maybe a way to compare settings against a fresh installed osc database? Any suggestions would be really helpful. THanks!!

 

No we would need examples of WHY you believe the database has an issue before we could comment.

[Tim Romero]

No we would need examples of WHY you believe the database has an issue before we could comment.

 

oh ok. When I get an order, I get email confirmation of it. The order ID is always "0". In Admin, the index page says I have orders, but when i click "pending", no orders are listed. Members can not log in and see order history either. That is my problem.

[♥FWR Media]

oh ok. When I get an order, I get email confirmation of it. The order ID is always "0". In Admin, the index page says I have orders, but when i click "pending", no orders are listed. Members can not log in and see order history either. That is my problem.

 

Well the orders_id field in the orders table is auto incremented which makes it sound like trashed PHP code to me at first glance.

[Tim Romero]

Well the orders_id field in the orders table is auto incremented which makes it sound like trashed PHP code to me at first glance.

 

Im not getting any PHP errors in my log. What page do you think I should look at to address this problem?

[Xpajun]

The data base wouldn't mess up of its own accord - what makes you think it is the database?

 

If someone has been playing in your database it might be an idea just to check that orders_id in the orders table is set for auto_increment

[Jack_mcs]

oh ok. When I get an order, I get email confirmation of it. The order ID is always "0". In Admin, the index page says I have orders, but when i click "pending", no orders are listed. Members can not log in and see order history either. That is my problem.

Go into phpmyadmin and select your database. Then search for "MODULE_ORDER_TOTAL_INSTALLED." There should be one result. Click on that and look at the configuration value. It should be

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

Also make the USE_PCONNECT and STORE_SESSIONS settings in your includes/configure.php file are set to use the database.

[Tim Romero]

Go into phpmyadmin and select your database. Then search for "MODULE_ORDER_TOTAL_INSTALLED." There should be one result. Click on that and look at the configuration value. It should be

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

Also make the USE_PCONNECT and STORE_SESSIONS settings in your includes/configure.php file are set to use the database.

 

Here is my configure info:

// define our database connection
 define('DB_SERVER', 'CORRECTSERVER'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'CORRECTUSERNAME');
 define('DB_SERVER_PASSWORD', 'CORRECTPASSWORD');
 define('DB_DATABASE', 'CORRECTDATABASE');
 define('USE_PCONNECT', 'true'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

I checked the MODULE_ORDER_TOTAL_INSTALLED. Mine is missing the ot_tax.php, Can this be my error? I dont calculate tax in my store for orders though.

[Tim Romero]

Go into phpmyadmin and select your database. Then search for "MODULE_ORDER_TOTAL_INSTALLED." There should be one result. Click on that and look at the configuration value. It should be

ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php

Also make the USE_PCONNECT and STORE_SESSIONS settings in your includes/configure.php file are set to use the database.

 

Here is my configure info:

// define our database connection
 define('DB_SERVER', 'CORRECTSERVER'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'CORRECTUSERNAME');
 define('DB_SERVER_PASSWORD', 'CORRECTPASSWORD');
 define('DB_DATABASE', 'CORRECTDATABASE');
 define('USE_PCONNECT', 'true'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

I checked the MODULE_ORDER_TOTAL_INSTALLED. Mine is missing the ot_tax.php, Can this be my error? I dont calculate tax in my store for orders though.

[Jack_mcs]

I checked the MODULE_ORDER_TOTAL_INSTALLED. Mine is missing the ot_tax.php, Can this be my error? I dont calculate tax in my store for orders though.

Save the current entry, make the change and try and order. If it works, problem solved. If not, switch the entry back.

[Tim Romero]

Save the current entry, make the change and try and order. If it works, problem solved. If not, switch the entry back.

 

Do i just type in ";ot_tax.php" into the "configuration value" field? if not, how do i make the change?

[Jack_mcs]

When you do the search for that item and it returns the one row, there will be an edit button in the display. Click on that, edit that box and save.

[Tim Romero]

When you do the search for that item and it returns the one row, there will be an edit button in the display. Click on that, edit that box and save.

ok. i did that. nothing changed, so i switched it back