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
Error in creating new article
Hi homer.j.simpson,
please have a look: http://www.phpwcms.de/forum/viewtopic.p ... icle#77584
Regards Knut
please have a look: http://www.phpwcms.de/forum/viewtopic.p ... icle#77584
Regards Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
-
- Posts: 24
- Joined: Sat 20. Jan 2007, 21:14
[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
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
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
If it is a fresh one, please kill all tables and run the db setup again.
Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
-
- Posts: 24
- Joined: Sat 20. Jan 2007, 21:14
[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".
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".