SQL Troubles

[austinderrick2]

In the admin area, I have having some VERY strange SQL problems...

 

I can not view orders or view customer's addresses...

 

What makes this REALLY strange is the fact that the information is in the database, just I cannot access it for some reason. All the other tables seem to be working fine; however, I even wrote a test script to the effect of "SELECT * FROM orders" and I could not return any results WHEN THE SCRIPT IS EXECUTED ON THE ORDERS PAGE!!!

It works, however, when I put it on a page by itself!

 

 

I got the customer's viewing to show some data by removing references to the address book, however, the customer's address information still does not show up...

 

I've tryed "echoing" the SQL and pasting it into the database - and it always returns results!?!?!?

 

 

This is one of the weirdest things I've ever seen...

 

Any ideas?

[Guest]

I've tryed "echoing" the SQL and pasting it into the database - and it always returns results!?!?!?

 

Why are you trying to echo the query to a database table ?

On the query page, echo out the query to the browser, then put in a exit(0).

Copy and paste the query into your SQL window in phpMyAdmin

 

Also - turn on all your php error warnings and notices. I think it is in the application_top file

 

You are getting a parse error, or php error somewhere. Find the error, fix the problem.

 

-C

[austinderrick2]

Why are you trying to echo the query to a database table ?

On the query page, echo out the query to the browser, then put in a exit(0).

Copy and paste the query into your SQL window in phpMyAdmin

 

Also - turn on all your php error warnings and notices. I think it is in the application_top file

 

You are getting a parse error, or php error somewhere. Find the error, fix the problem.

 

-C

 

 

It's the weirdest thing I've ever seen. No errors, I've even put in error_reporting(E_ALL); at the top of the page to make sure. As for the MySQL part - I've echoed out the query to the browser, copied and pasted it and it returns rows - but for some reason, when I run the EXACT same query on the page, I do not get any results. (No errors, but also no results)

[austinderrick2]

It's the weirdest thing I've ever seen. No errors, I've even put in error_reporting(E_ALL); at the top of the page to make sure. As for the MySQL part - I've echoed out the query to the browser, copied and pasted it and it returns rows - but for some reason, when I run the EXACT same query on the page, I do not get any results. (No errors, but also no results)

 

 

Oh wow, changing the error reporting the in application_top.php makes a HUGE difference... It ignores it if you do it on the individual page... **Digging into errors now**

[austinderrick2]

Oh wow, changing the error reporting the in application_top.php makes a HUGE difference... It ignores it if you do it on the individual page... **Digging into errors now**

 

 

Well here is what I get, but I dont think any of this is causing the errors...

 

Notice: Constant MODULE_PAYMENT_CC_ZONE already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_ORDER_STATUS_ID already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_ZONE already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_TOTAL_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MAX_DISPLAY_PRODUCTS_NEW already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_SHIPPING_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_SHIPPING_DESTINATION already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_COD_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_COD_ORDER_STATUS_ID already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_COD_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_COD_ZONE already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_EMAIL already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_ORDER_STATUS_ID already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_ZONE already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_EMAIL already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_TAX_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_TAX_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_ORDER_TOTAL_SUBTOTAL_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_ZONE already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_ORDER_STATUS_ID already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_EMAIL already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_EMAIL already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_PAYMENT_CC_ORDER_STATUS_ID already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_SHIPPING_USPS_STATUS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_SHIPPING_USPS_USERID already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_SHIPPING_USPS_PASSWORD already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_SHIPPING_USPS_HANDLING already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_SHIPPING_USPS_TAX_CLASS already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_SHIPPING_USPS_ZONE already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Notice: Constant MODULE_SHIPPING_USPS_SORT_ORDER already defined in /home/cannonra/public_html/catalog2/admin/includes/application_top.php on line 68

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/cannonra/public_html/catalog2/admin/includes/application_top.php:68) in /home/cannonra/public_html/catalog2/admin/includes/functions/sessions.php on line 102

[austinderrick2]

Arg stupid mistake... When we upgraded to version 2 we made a new database, but the configuration in the admin area was still pointing to the old database; while the user side was pointing to the new database...