Print Page - SQL Logic error when installing mod

Title: SQL Logic error when installing mod
Post by: Putnam on March 21, 2009, 12:38:08 AM

I downloaded SMF Links from http://www.smfhacks.com/hacks/SMF-Links.html 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

Title: Re: SQL Logic error when installing mod
Post by: karlbenson on March 21, 2009, 10:34:13 AM

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

Title: Re: SQL Logic error when installing mod
Post by: vbgamer45 on March 21, 2009, 04:39:10 PM

At this time I will not be able to support any database system other mysql since that is the only system I have installed.

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => PostgreSQL and SQLite Support => Topic started by: Putnam on March 21, 2009, 12:38:08 AM