Error When uploading

by **unistorm** » Sat Jul 08, 2006 10:51 am

receiving error when uploading after installing maxresist

Code: Select all: 1064: You have an error in your SQL syntax near '(replace(SUBSTRING(item_tooltip,LOCATE('All Resistances ', item_tooltip,LOCATE('' at line 1

by **Mathos** » Sun Jul 09, 2006 3:24 pm

Post a link to your roster and also post the SQL debug box code.

by **unistorm** » Wed Jul 12, 2006 7:19 am

http://www.ugotgankd.com/roster/

no debug info. sorry

by **Balmark** » Wed Jul 12, 2006 2:45 pm

Does anyone have this working ok with the latest characterprofiler and latest wowroster?

With 1.6.0 wow roster, and max resist was working fine with the trigger.php I got from this forum pre-hack

I wiped and installed 1.7.0 wow roster, installed the latest max.resist
and it's just not working. Fails on the update trigger and fails on the viewing of individual res equipment of characters

eg.
http://www.thepure.net/roster/addon.php ... Resistance

results in:
1064: You have an error in your SQL syntax near '(replace(SUBSTRING(item_tooltip,LOCATE('Fire Resistance
', item_tooltip,LOCATE('' at line 1

and the updating trigger failure message is
1064: You have an error in your SQL syntax near '(replace(SUBSTRING(item_tooltip,LOCATE('All Resistances ', item_tooltip,LOCATE('' at line 1

by **Diska** » Wed Jul 12, 2006 6:47 pm

This addon is most certainly compatible with Roster 1.7.

According to http://www.thepure.net/roster/phpinfo.php you are running MySQL 3.23 which is *quite* old. I'll bet the problems would disappear if you upgraded to 4.0 at the very least.

by **Sahasrahla** » Wed Jul 12, 2006 7:13 pm

Diska wrote:This addon is most certainly compatible with Roster 1.7.

According to http://www.thepure.net/roster/phpinfo.php you are running MySQL 3.23 which is *quite* old. I'll bet the problems would disappear if you upgraded to 4.0 at the very least.

http://www.sahasrahla.net/7sins/phpinfo.php
I'm using 3.23.49 and everything is working brilliantly, including my Max.resist on Roster 1.7...

by **Diska** » Wed Jul 12, 2006 7:28 pm

hmm, so that's not the problem either...weird, then I'm afraid I have no clue

by **Balmark** » Thu Jul 13, 2006 1:55 pm

Hmm ok it works with 1.7.0 .. I gotta figure this out, its probably just something simple on my side, I'll get back to you if I ever sort it ugh

Really miss this addon

by **Armageden** » Sat Nov 04, 2006 8:45 am

I am getting the same error....
1064: You have an error in your SQL syntax near '(replace(SUBSTRING(item_tooltip,LOCATE('All Resistances ', item_tooltip,LOCATE('' at line 1

Tried everything and i cant figure it out.

by **Armageden** » Mon Nov 06, 2006 7:51 am

I have been messing with this for a while now and i cant figure it out. i am using an older mySQL.

http://wowtoughlove.com/wowroster/phpinfo.php

This program would be a great asset for my guild and i would love to get it to work. Can some one please help me????