CE Phoenix Cart Forum

Was adding products and everything was working perfect.

Now when product is added, completes the addition with no errors but new product doesn't show in the product list

Checking in the database shows 0 for product id rather than the sequential product number.

1.0.8.0

Not sure what the issue actually was.

Stupid mans fix!

Go into products and change the product id to next sequential number.
Go into products_to_categories and make same number change

We'll see when I add another product.

Check that in the database products table the products id has auto increment set.
I’m also wondering how you got this screwed up. Do you have a dB backup from a point where your settings were correct. It might be easier to restore even you have to enter some products again.

Still won't auto increment

SQL query:
ALTER TABLE `products`
MODIFY `products_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=334

MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

Then check if you have another column set to auto increment and remove it.
Or recover a backup, if you have, from a point where the settings where ok.
I wonder how you got these settings wrong.

Also make sure that the products_id column is defined as the primary key for the products table.

product_id is Primary and only key set on products table.

Refuses to auto_increment.

Dnj1964 wrote: ↑Sat Apr 03, 2021 12:13 am product_id is Primary and only key set on products table.

Refuses to auto_increment.

OK. Try the ALTER statement again. It's certainly not going to auto-increment until you set it to auto-increment.

And note, what you need to check is not that it is the only key but that it is the only auto-increment column.

Here's the problem. The PRIMARY is not in that statement. So when you run it, it tries to remove the primary key and then it can't be used as an auto_increment. Try That should retain the status as a key and add the auto_increment property.

ecartz wrote: ↑Sat Apr 03, 2021 3:49 am

Code: Select all

ALTER TABLE `products`
MODIFY `products_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=334

Here's the problem. The PRIMARY is not in that statement. So when you run it, it tries to remove the primary key and then it can't be used as an auto_increment. Try

Code: Select all

ALTER TABLE `products`
MODIFY `products_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, AUTO_INCREMENT=334

That should retain the status as a key and add the auto_increment property.

@ecartz Thanks ever so much, that worked perfectly