Getting database errors

[stacy]

All,

Using v1.3.7

I am experiencing something simular.

In the admin screen whenever I click on a link I get

1062 Duplicate entry '2498' for key 1 in:

[insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'categories.php', '', '217.231.151.126')]

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.


Of course the file changes each time I use a different link.

Any thoughts?

[DrByte]

stacy,
Your problem is a little different.

You are likely a missing auto-increment setting on the admin_activity_log table.
You could try fixing that by running this command via phpMyAdmin:

ALTER TABLE admin_activity_log CHANGE log_id log_id int(15) NOT NULL auto_increment;

The auto-increment setting usually doesn't get lost unless moving databases from one host to another and going from MySQL v3.x to v4.x and selecting the wrong combination of compatibility settings.

[stacy]

Dr. B

I will try that.. but I really am new at this.

When you say Run this via Myphpadmin.. what do you mean exactly?

I opened MyPHPAdmin but I am at a loss how to "run" this.

Stacy

[DrByte]

I opened MyPHPAdmin but I am at a loss how to "run" this.

1. Select your Zen Cart database from the pulldown list
2. Click on the SQL tab
3. Paste the code I posted above into the input area, and click Go

[stacy]

Error

SQL query:
ALTER TABLE admin_activity_log CHANGE log_id log_id int( 15 ) NOT NULL AUTO_INCREMENT
MySQL said:
#1146 - Table 'redhell4_zc1.admin_activity_log' doesn't exist

That is all I got.... :-)

[DrByte]

Slight change required because your site is using "table prefixes" of "zen_", like this:

ALTER TABLE zen_admin_activity_log CHANGE log_id log_id int(15) NOT NULL auto_increment;

[stacy]

Yep, saw that and fixed it...

Thanks.. I would not have gotten it without you.

Stacy

[stacy]

For the love God.. now I am getting this when I try and look at the products. Only 2 catagories come up.. 1 and 4.

1030 Got error 134 from storage engine
in:
[select count(*) as total from zen_products p, zen_products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = 1 and p2c.categories_id = '1']


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.