Can't save new entries

[Ralf Skirr]

Hi,

so far I saved 1 entry. After that I installed the 'extended properties of articles' plugin.

Now I can't save new articles. After clicking save this error message is shown:

INSERT INTO serendipity_entries (title,timestamp,body,extended,isdraft,allow_comments,moderate_comments,exflag,comments,last_modified,author,authorid) values ('Test', '1208970443', 'Test\r\n', '', 'false', 'false', 'false', '0', '0', '1208970443', 'CMS_admin', '1')

/ Duplicate entry '0' for key 1

Any idea how to fix this?

Thanks,

[garvinhicking]

Hi!

Your mysql database is bad, you are missing the autoincrement key on the 'id' column. Looks like you migrated your database from a SQL dump but forgot to include all create table options.

Regards,
Garvin

[Ralf Skirr]

Hi Garvin,

actually it was a fresh installation.

Since there is no content yet I could simply delete it and make a new install.

Would that be the best thing to do?

Ralf

[judebert]

If it was a fresh installation, then your database user probably doesn't have all the necessary permissions, or your database is unsupported. Reinstallation won't do any good until that problem is fixed.

Of course, it could've been a one-time glitch. Reinstallation isn't a big problem; go ahead and see if it works.

[Ralf Skirr]

Thanks.

The database is mysql, controlled via phpmyadmin. General cp is Plesk.

How can I find out about the rights? Is this info visible in phpmyadmin or plesk?

Ralf

[judebert]

I don't know about Plesk; my hosting service uses cpanel.

The user will require CREATE, INSERT, UPDATE, DELETE, ALTER and INDEX privileges. When I created my database, the cpanel tool allowed me to create users and assign them privileges. I would be mildly surprised if Plesk didn't work the same way.

I don't see any way to find the user permission information from phpMyAdmin. You'll have to speak to your hosting service to find out.

Good luck!