bug in meta-tags area causing MySQL errors?

[chris hill]

I started putting in meta-tags per the system in admin.

When you do this, it causes problems in the database, leaving open ended areas that supply requests to the entire database. Approximately 5,000 requests for a single product.

After putting in three products with the meta-tags, the system stops working on some servers as it says it has gone over 50,000 requests to the database for the user in under an hour.

The error shows up on screen as follows:

1226 User '******' has exceeded the 'max_questions' resource (current value: 50000)
in:
[update products set products_price_sorter='16.1900' where products_id='689']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

This requires that you delete and re-enter the user and the password in the database.

When the database is checked for errors, the following shows up as warnings in the tables. The warnings are open areas where the databases are expecting responses.

Table Name Status
admin_activity_log Warning
meta_tags_products_description Warning
products Warning
sessions Warning
specials Warning
whos_online Warning

Note that this is only happening with using the admin meta-tag system.

The information on the system is as follows:

Zen Cart 1.3.0.2
Database Patch Level: 1.3.0.2
v1.3.0.2 [2006-08-18 14:19:07] (Fresh Installation)

Database Host: localhost (127.0.0.1)
Server OS: FreeBSD 4.11-STABLE
Database: MySQL 4.0.16
Server Date: 08/28/2006 16:52:55
Database Date: 08/28/2006 16:52:55
Server Up Time: 4:52PM up 31 days, 2:39, 1 user, load averages: 1.19, 0.97, 0.93
PHP Version: 4.4.1 (Zend: 1.3.0)
HTTP Server: Apache

I consulted with a couple of people and they agree that something in the code is causing the problem. I am not really familiar with using MySQL commands, so I have no suggestions as to solutions.

I beleive this is a bug as it is leaving open database tables and causing cascading requests to the database.

Chris Hill

[DrByte]

Here's at least a workaround for cases where hosts are throttling their database activity:
http://www.zen-cart.com/forum/showthread.php?t=24089

[chris hill]

Thanks, this will help.

Any ideas as to the area of the code that is leaving the tables open?

Chris

[DrByte]

I suspect those table-open issues are related to your host's configuration of the database.

And likely the main cause for the tables being left "open" would be the errors you're encountering due to query-throttling.


Zen Cart does not use persistent connections by default, and thus the explicit database-connection-close has been disabled in favor of an implicit close.

If your hosting configuration doesn't like that, you could go to:
/admin/includes/application_bottom.php
approx line 22:

  //  $db->close();

and uncomment the line by removing the //

[chris hill]

Thanks.

I'll do that.

Chris

[chris hill]

I haven't changed anything on the server yet, but now the following comes up.

The database shows as fully functional, so I don't know what is happening.

1016 Can't open file: 'sessions.MYI'. (errno: 145)
in:
[select value from sessions where sesskey = '85fe9da0221de8454e938da56300da4b' and expiry > '1156816379']

[Ajeh]

That sounds like the result of a MySQL crash ...

Go into phpMyAdmin and run a Repair on the sessions table and see if this fixes that issue ...

NOTE: Backups are strongly recommended on a regular basis ...

[DrByte]

Any ideas as to the area of the code that is leaving the tables open?

Maybe it's not the code at all ...