Error in creating new article

Please post all install related problems here. Visit this forum first for troubleshooting.
Post Reply
homer.j.simpson
Posts: 24
Joined: Sat 20. Jan 2007, 21:14

Error in creating new article

Post by homer.j.simpson »

I have problem in creating new article. I just kept on receving "error while connecting to database" message. I also tried to excute that sql command in phpmyadmin but doesn't work. Any idea why?

SQL command
[Quote]
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 ('6','1','goadmin','Test Article','Testing','1','1','2007-02-01 22:33:26','2017-01-29 23:59:59','','', 10,0, '1170387206', '', '', 1, 0, 0, 1);
[/Quote]

Error shown by phpmyadmin
[Quote]
#1364 - Field 'article_summary' doesn't have a default value
[/Quote]

PHP - 5.1.2
MYSQL - 5.0.2
APACHE - 2
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

Hi homer.j.simpson,

please have a look: http://www.phpwcms.de/forum/viewtopic.p ... icle#77584

Regards Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
homer.j.simpson
Posts: 24
Joined: Sat 20. Jan 2007, 21:14

Post by homer.j.simpson »

[quote="flip-flop"]Hi homer.j.simpson,

please have a look: [url]http://www.phpwcms.de/forum/viewtopic.p ... icle#77584[/url]

Regards Knut[/quote]

I followed the link and did as they mentioned. I run upgrade.php and did some upgrade. It also show sql error. I also run that sql update files through phpmyadmin and still show error, like "Duplicate field name". Is there any way to solve this?

P.S phpwcms version 1.2.8
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

Is it a fresh installation or an update?
If it is a fresh one, please kill all tables and run the db setup again.

Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
homer.j.simpson
Posts: 24
Joined: Sat 20. Jan 2007, 21:14

Post by homer.j.simpson »

[quote="flip-flop"]Is it a fresh installation or an update?
If it is a fresh one, please kill all tables and run the db setup again.

Knut[/quote]
Yes it is fresh installation and I delete all tables before I install. I even delete the phpwcms folder and unzip the files again. But I didn't manage to delete some folders which is not reside in phpwcms. So I got errors in last step of setup like "folder aready exist".
Post Reply