Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Error (0) returned from SQL Query
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Error (0) returned from SQL Query
#54985
Error (0) returned from SQL Query 9 Years, 5 Months ago Karma: 0
I recently moved my site from a shared server to a virtual server. After making the move, I updated the SQL server information for the tablet I'm trying to display, but the database isn't loading on the front end. You can view it here: dev.tubemethods.com/db. It returns the error:
Code:

(mysql): SELECT * FROM specs;
Error (0):  



I'm using the simple SELECT query to a table that has more than 9,000 entries. It's identical to the old server, but I get this error. Any ideas or places to start. MySQL configuration issue on my server?

The user has all privileges assigned to the database.

Thanks!
Keith
The administrator has disabled public write access.
 
#54988
Re:Error (0) returned from SQL Query 9 Years, 5 Months ago Karma: 760
Hello,

"Error (0)" means no error occurs and it is shown because "SQL -> Debug" parameter is set "Yes" in module settings. Probably the table is empty fate a migration to a new server. Try to execute the following query:

SELECT COUNT(*) FROM specs

and the following one:

SHOW COLUMNS FROM specs

Regards,
ARI Soft
The administrator has disabled public write access.
 
#55002
Re:Error (0) returned from SQL Query 9 Years, 5 Months ago Karma: 0
Thanks for the response.

I see what you mean about the error. If I turn off the jQuery loader, the raw data appears, but it's totally unformatted.

If I inspect the page on Chrome, I see a series of Console errors:
Code:

Uncaught SyntaxError: Unexpected end of input
db:236 Uncaught ReferenceError: BTLJ is not defined
db:36 Uncaught TypeError: $(...).addClass(...).dataTable is not a function
db:38 Uncaught ReferenceError: JCaption is not defined



This is the only page on the site that's returning any errors, so I'm thinking there may be an issue with the plugin. I'm also having issues (only when on this page) using any other javascript elements, such as the red warning box "x" that is directly above where the table should display and the "lock" icon in the top right corner.

This seems to be related to why the loader never changes to reveal the data, and when I don't use the loader, the data displays, but not in any sort of format similar to the Ari Data Tables view.

The link again is dev.tubemethods.com/db. I was using Google Chrome and the built in inspector.

Thanks!
Keith
The administrator has disabled public write access.
 
#55004
Re:Error (0) returned from SQL Query 9 Years, 5 Months ago Karma: 760
It seems this is a problem with plugin which is used to optimise javascript files loading. Try to disable it (jchoptimize plugin).

Regards,
ARI Soft
The administrator has disabled public write access.
 
#55020
Re:Error (0) returned from SQL Query 9 Years, 5 Months ago Karma: 0
Not sure how I missed that. Thanks so much! Fixed it instantly.
The administrator has disabled public write access.
 
Go to topPage: 1