cannot create an article

Please post all install related problems here. Visit this forum first for troubleshooting.
Post Reply
ctjies
Posts: 2
Joined: Wed 29. Nov 2006, 17:24

cannot create an article

Post by ctjies »

after manually install the wcms and manually created the webmaster account. i can create the structure of the website.
But when i wnt to create an article i get:

error while connecting to database:

INSERT INTO phpwcms_article (article_cid, article_uid, article_username, article_title, article_keyword, article_public, article_aktiv, article_begin, article_end, article_subtitle, article_redirect, article_sort, article_notitle, article_created, article_cache, article_nosearch, article_nositemap, article_aliasid, article_headerdata, article_morelink) VALUES ('11','1','webmaster','hallo','','1','1','2006-12-04 16:32:40','2016-12-01 23:59:59','','', 10,0, '1165246360', '', '', 1, 0, 0, 1);

Help!
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

Hi ctjies,

I think there are some tables of your db not right.

One thing: Are at your db tables the auto_increment set?
Have a look via phpMyAdmin.

Please make a forum search: "INSERT INTO phpwcms_article"
Ther yo will find some hints.

e.g.:
http://www.phpwcms.de/forum/viewtopic.php?p=52051#52051
http://www.phpwcms.de/forum/viewtopic.php?p=31677#31677

Regards Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
possum
Posts: 1
Joined: Wed 7. Mar 2007, 01:56

Post by possum »

After disabling the SQL strict mode in MySQL it worked for me
StasMark
Posts: 11
Joined: Tue 22. May 2007, 16:29

Post by StasMark »

flip-flop wrote:Hi ctjies,

One thing: Are at your db tables the auto_increment set?
Have a look via phpMyAdmin.
Where I can see it and how unset it?

phpMyAdmin - 2.10.1
MySQL client version: 4.0.27
Server version: 4.0.27-standard-log
StasMark
Posts: 11
Joined: Tue 22. May 2007, 16:29

Post by StasMark »

I don't understan,
auto_increment is need or not?

As I see in my server with phpMyAdmin, its not set... If it need, how with phpMyAdmin set auto_increment?
Post Reply