Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [shann123] upgrade from dbman to dbmansql 1

Quote Reply
Re: [shann123] upgrade from dbman to dbmansql 1 In reply to
Just when I thought everything was going good...

I just discovered that when I logged in to an account without admin permissions, I can't modify a record, it works fine when you have admin permissions. This is the error that I get when trying to modify a record without being admin:

CGI ERROR
==========================================
Error Message : Unable to query database. Reason: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(
ID >= 0 ) AND
. Query:
SELECT ID,Name,Playername,Location,Sex,Orientation,Relationship,Age,birthmonth,birthday,icq,aim,yahoo,msn,URL,profession,CorBBits,dressing,alchdrink,dipping,pillow,pets,music,band,movies,TV,car,toothpaste,foods,dessert,chill,visit,icecream,drink,bedtime,shoes,scent,sport,color,cartoon,handed,game,bum,pizza,candy,store,book,boxers,pcomments,comments,Email,Validated,userid,since,Graphic,cap1,cap2,cap3,cap4,cap5,cap6 FROM Items
WHERE
ID >= 0 (
ID >= 0 ) AND
userid = 'test1'

LIMIT 0, 25

Script Location : db.cgi
Perl Version : 5.008
Setup File : db.cfg
User ID : test1.67351

Form Variables
-------------------------------------------
ID : *
db : db
modify_form : 1
uid : test1.67351


Any ideas? I'm lost on this and getting the validate mod to work. *sighs* This is getting really frustrating and I'm about ready to just give up. Unsure


DBMan SQL Version 1 mods available at:
http://dbmansqlmods.rainbowroomies.com
(Mods based on JPDeni's original mods.)
Subject Author Views Date
Thread upgrade from dbman to dbmansql 1 shann123 12275 Jan 19, 2004, 5:06 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
ltillner 12060 Jan 22, 2004, 1:37 PM
Thread Re: [ltillner] upgrade from dbman to dbmansql 1
shann123 12115 Jan 22, 2004, 2:18 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 12073 Jan 23, 2004, 6:08 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 12094 Jan 24, 2004, 6:52 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 12050 Jan 24, 2004, 7:08 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 12047 Jan 25, 2004, 4:50 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
ltillner 12074 Jan 26, 2004, 8:37 AM
Thread Re: [ltillner] upgrade from dbman to dbmansql 1
shann123 12041 Jan 26, 2004, 1:08 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 12052 Jan 27, 2004, 4:58 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 12036 Jan 27, 2004, 6:48 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 12028 Jan 30, 2004, 10:06 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
timbo 11998 Feb 5, 2004, 11:13 AM
Post Re: [timbo] upgrade from dbman to dbmansql 1
shann123 11995 Feb 8, 2004, 12:10 AM
Thread Re: [timbo] upgrade from dbman to dbmansql 1
ltillner 11987 Feb 10, 2004, 11:24 AM
Thread Re: [ltillner] upgrade from dbman to dbmansql 1
shann123 11894 Mar 2, 2004, 3:21 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11903 Mar 2, 2004, 5:54 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11875 Mar 3, 2004, 2:23 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11846 Mar 3, 2004, 6:35 PM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11862 Mar 4, 2004, 4:36 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11858 Mar 6, 2004, 8:17 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11840 Mar 7, 2004, 7:20 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11865 Mar 8, 2004, 4:37 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11852 Mar 10, 2004, 10:24 AM
Thread Re: [shann123] upgrade from dbman to dbmansql 1
shann123 11818 Mar 11, 2004, 11:59 AM
Post Re: [shann123] upgrade from dbman to dbmansql 1
shann123 1696 Mar 16, 2004, 5:44 AM