I recently download a Pixel Script. But installation error occured.
GPix Pixel Ad Script 1.4.0 Installer
Internal Error
The following unexpected error occurred:
An error occurred during the upgrade: ALTER TABLE mp_categories CHANGE id id INT( 11 ) NOT NULL AUTO_INCREMENT [nativecode=1075 ** Incorrect table definition; there can be only one auto column and it must be defined as a key]
Please can anybody help me to solve this problem?
That is not a PHP error. It is caused because the script you are installing wants to alter a database and most likely does not have permission to do so. A quick search on google gave a LOT of sites to read. Check there and read a few pages.
I suggest using “GPix Pixel Ad Script 1.4.0 Installer nativecode=1075” for your search query (no quotes)
Sorry, I doubt many here have installed this advertising add on…
Ernie is right… your issue is probably a privilege one.
I would suggest to go to your PhpMyAddmin and locate your project’s database, then under Privileges, choose the username of your database and click the edit button (pencil icon) to open it.
Finally, and under Structure make sure ALTER is checkqued.
I had a similar issue the other day and this solved it for me. I hope it works for you. Good luck!