SQL data Base Error

CharacterProfiler.lua file uploading issues

SQL data Base Error

Postby chrisdb » Fri Mar 05, 2010 2:15 pm

The roster runs very well, cons I found this by updating the various character I:

Database Error
1064: 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 'ombre' ORDER BY `spell_name`' at line 1
SQL:
SELECT * FROM `roster_spellbook` WHERE `member_id` = '85' AND `spell_type` = 'Magie de l'ombre' ORDER BY `spell_name`;
File: lib/dbal/mysql.php
Line: 234

can you help me?
is this a known bug.
thanks,
chrisdb
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Feb 12, 2010 5:20 pm

Re: SQL data Base Error

Postby zanix » Fri Mar 05, 2010 7:02 pm

What version of Roster do you have?
What page is this error found on?
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: SQL data Base Error

Postby Adric » Sat Mar 06, 2010 7:19 am

Heres part of the problem...

SELECT * FROM `roster_spellbook` WHERE `member_id` = '85' AND `spell_type` = 'Magie de l'ombre' ORDER BY `spell_name`;

doesnt look like the interior ' was stripped out...
User avatar
Adric
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 61
Joined: Wed Jul 05, 2006 7:52 am

Re: SQL data Base Error

Postby Ulminia » Sat Mar 06, 2010 9:08 am

yea ial check the svn call code and update.lib and make sure its adding slashes for next ver..
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: SQL data Base Error

Postby chrisdb » Sat Mar 06, 2010 10:04 am

ok thanks
chrisdb
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Feb 12, 2010 5:20 pm

Re: SQL data Base Error

Postby chrisdb » Tue Mar 09, 2010 10:48 am

Hey,

A new problem

what's that ??


Database Error

1062: Duplicate entry '90-Tree of Life' for key 1
SQL:
INSERT INTO `roster_buffs` SET `member_id` = '90', `name` = 'Tree of Life', `icon` = 'ability_druid_treeoflife', `rank` = 'Shapeshift', `tooltip` = 'Tree of Life\nImmune to Polymorph effects. Increases healing recieved by 6% for all party and raid members within 45 yards.'
File: lib/dbal/mysql.php
Line: 234
chrisdb
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Fri Feb 12, 2010 5:20 pm

Re: SQL data Base Error

Postby Betelgeuse » Thu Apr 01, 2010 5:13 pm

Well I found an easy fix for this. Make sure you don't logout in Tree form on your druid. Then it works.
Betelgeuse
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Apr 01, 2010 5:11 pm


Return to Uploading

Who is online

Users browsing this forum: No registered users and 1 guest

cron