SMF Support > PostgreSQL and SQLite Support

SQL Logic error when installing mod

(1/1)

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:

--- Quote ---Database Error
SQL logic error or missing database
near "NOT": syntax error
File: /www/***********************/htdocs/Packages/temp/linksql2.php
Line: 20
--- End quote ---

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.

Navigation

[0] Message Index