Re: weblog install error [Module troubleshooting]

weblog install error

2009/4/14 3:29
fredgsanford
Just popping in
Posts: 98
Since: 2004/6/29

I'm getting this error when trying to install weblog 1.4.1 on XOOPS 2.0.17:

Installing weBLog

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads int(100) NOT NULL default '0', trackbacks int(11) NOT NULL default '0', ' at line 10

Unable to install weblog. Error(s):

Can anybody tell me how to fix this and get it working?
Thanks

Re: weblog install error

2009/4/14 7:51
ghia
Community Support Member
Posts: 4953
Since: 2008/7/3 1

Probably a problem with the newer version of mysql.
Edit the /sql/mysql.sql file and change all default '0' to default 0 (without quotes and for all fields which are int(egers)).
Another problem might be the int(100), it should be int(10).

The art of asking questions.

Re: weblog install error

2009/4/14 9:53
xgarb
Not too shy to talk
Posts: 154
Since: 2003/3/30

hhttps://xoops.org/modules/newbb/viewtopic.php?viewmode=flat&type=&topic_id=63220&forum=28

https://xoops.org/modules/newbb/viewtopic.php?viewmode=flat&type=&topic_id=62386&forum=28

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

weblog install error

Re: weblog install error

Re: weblog install error

Login

Search

Recent Posts

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}