1
fredgsanford
weblog install error

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

2
ghia
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).

3
xgarb
Re: weblog install error
  • 2009/4/14 9:53

  • xgarb

  • Not too shy to talk

  • Posts: 154

  • Since: 2003/3/30


https://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

Login

Who's Online

162 user(s) are online (90 user(s) are browsing Support Forums)


Members: 0


Guests: 162


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits