If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Advanced poll, postgresql and errors  XML
Forum Index » Support Forum
Author Message
Anonymous



I'm trying to configure poll with postgresql and generally everyything is ok, except small bugs - in file class_pgsql.php line
$query_strg = eregi_replace("limit ([0-9]+),([ 0-9]+)", "limit \\2, \\1", $query_strg);

should be replaced with:
$query_strg = eregi_replace("limit ([0-9]+),([ 0-9]+)", "limit \\2 offset \\1", $query_strg);

because of syntax of postgresql query.
But I have a second bug - when I'm clicking on poll (for example Demo1->Advanced poll) without previously selecting any item I've got an error:
Error : Query Error
Message : ERROR: invalid input syntax for integer: ""

Is here anybody who knows the solution?
Auron
Expert
[Avatar]

Joined: 23/06/2003 22:02:17
Messages: 1053
Offline

Integers in SQL queries should be on their own not in double quotes.

Auron

Visit my site @ www.ragnaru.com
Adv. Poll Install Guide NOW BACK ONLINE! (And also rather out of date I would of thought)
[Email] [WWW]
 
Forum Index » Support Forum
Go to:   
Based on the open source JForum