Advertisement:

Author Topic: SQL Logic error when installing mod  (Read 8071 times)

Offline Putnam

  • Semi-Newbie
  • *
  • Posts: 19
SQL Logic error when installing mod
« on: March 21, 2009, 12:38:08 AM »
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

Any help?
I'm using 2.0RC1 with SQLite

Offline karlbenson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,584
  • Gender: Male
    • @mortonssols on Twitter
    • Criminal Solicitors
Re: SQL Logic error when installing mod
« Reply #1 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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 16,646
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SQL Logic error when installing mod
« Reply #2 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.
Community Suite - Take your forum to the next level built for SMF, Gallery,Store,Classfieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Latest Mod:
EzPortal - Portal System for SMF
Newsletter Pro SMF Gallery Pro SMF Classifieds SMF Store