News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

SQL Logic error when installing mod

Started by Putnam, March 21, 2009, 12:38:08 AM

Previous topic - Next topic

Putnam

I downloaded SMF Links from http://www.smfhacks.com/hacks/SMF-Links.html [nofollow] and When I tried to extract it I got this error:
QuoteDatabase Error
SQL logic error or missing database
near "NOT": syntax error
File: /www/***********************/htdocs/Packages/temp/linksql2.php
Line: 20

Any help?
I'm using 2.0RC1 with SQLite

karlbenson

The mod will not work on Sqlite OR PostGreSql, because the mod author has used the wrong functions to create the table.

I'd suggest contacting the mod author and asking to make it compatible with all 2.0 supported database types by using the
$smcFunc['db_create_table']
instead of
$smcFunc['db_query']

(not it isn't just a straight swap, the query needs re-writing into an array type function)
http://support.simplemachines.org/function_db/index.php?action=view_function;id=606

vbgamer45

At this time I will not be able to support any database system other mysql since that is the only system I have installed.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: