Multiple SQL Errors

Help and support in getting the EVE-Dev Killboard to run on your site.
LogicSequence
Noob
Posts: 7
Joined: Wed Oct 05, 2011 10:20

Re: Multiple SQL Errors

Post by LogicSequence » Sun Jun 09, 2013 00:57

Database error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and d.attributeID in (137,602)' at line 5
SQL: select itt_slot from kb3_item_types inner join kb3_dgmtypeattributes d where itt_id = d.value and d.typeID = and d.attributeID in (137,602);
ERROR [256] SQL error (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and d.attributeID in (137,602)' at line 5
Error on line 46 in file /COA/www/killboard/common/includes/class.dbnormalquery.php
PHP 5.4.16 (Linux), EDK 4.0.4 (Crucible)
File: /COA/www/killboard/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error
File: /COA/www/killboard/common/includes/class.item.php, line: 152, class: DBNormalQuery, function: execute
File: /COA/www/killboard/common/includes/class.idfeed.php, line: 806, class: Item, function: getSlot
File: /COA/www/killboard/common/includes/class.idfeed.php, line: 556, class: IDFeed, function: processItem
File: /COA/www/killboard/common/includes/class.idfeed.php, line: 485, class: IDFeed, function: processKill
File: /COA/www/killboard/common/includes/class.idfeed.php, line: 138, class: IDFeed, function: processFeed
File: /COA/www/killboard/common/admin/admin_idfeedsyndication.php, line: 155, class: IDFeed, function: read
File: /COA/www/killboard/common/admin/admin_idfeedsyndication.php, line: 83, function: getIDFeed
File: /COA/www/killboard/common/index.php, line: 293, function: include
File: /COA/www/killboard/index.php, line: 27, function: include
I'm getting this error when fetching kills now as well, even after i applied the fix in the thread linked above. :( I don't know what to do, any ideas?

Unknown_Terror
Greenhorn
Posts: 18
Joined: Sat Jun 14, 2008 20:24

Re: Multiple SQL Errors

Post by Unknown_Terror » Wed Dec 11, 2013 15:35

Hi guys, I applied the fixes suggested and they work a charm as I was having the same issue as problem 1 of the OP. I'm still getting one error though.
ERROR [256] Invalid mail, invalid involved weapon
Error on line 624 in file /home1/madbags/public_html/ulv/common/includes/class.kill.php
PHP 5.2.17 (Linux), EDK 4.0.4 (Crucible)
File: /home1/madbags/public_html/ulv/common/includes/class.kill.php, line: 624, function: trigger_error
File: /home1/madbags/public_html/ulv/common/includes/class.kill.php, line: 1665, class: Kill, function: getRawMail
File: /home1/madbags/public_html/ulv/common/includes/class.kill.php, line: 1373, class: Kill, function: getHash
File: /home1/madbags/public_html/ulv/common/includes/class.idfeed.php, line: 559, class: Kill, function: add
File: /home1/madbags/public_html/ulv/common/includes/class.idfeed.php, line: 485, class: IDFeed, function: processKill
File: /home1/madbags/public_html/ulv/common/includes/class.idfeed.php, line: 138, class: IDFeed, function: processFeed
File: /home1/madbags/public_html/ulv/common/admin/admin_idfeedsyndication.php, line: 155, class: IDFeed, function: read
File: /home1/madbags/public_html/ulv/common/admin/admin_idfeedsyndication.php, line: 83, function: getIDFeed
File: /home1/madbags/public_html/ulv/common/index.php, line: 293, function: include
File: /home1/madbags/public_html/ulv/index.php, line: 27, function: include
It could take me forever to find the actual killmail causing the problem but I don't know if anyone has a solution to this?

Thanks

User avatar
Eowarebin
Greenhorn
Posts: 30
Joined: Thu Oct 03, 2013 00:13

Re: Multiple SQL Errors

Post by Eowarebin » Wed Jan 01, 2014 01:44

dbrummer wrote:Upgrading to the Inferno data dump, http://eve-id.net/forum/viewtopic.php?f=503&t=18752, fixes the first SQL syntax error.
Unable to get into that forum.

Fuegor
Developer
Posts: 80
Joined: Wed Aug 15, 2012 23:23

Re: Multiple SQL Errors

Post by Fuegor » Wed Jan 01, 2014 14:39

Eowarebin wrote:
dbrummer wrote:Upgrading to the Inferno data dump, http://eve-id.net/forum/viewtopic.php?f=503&t=18752, fixes the first SQL syntax error.
Unable to get into that forum.
The link has the old forum host inside. Just replace eve-id.net with evekb.org and it will work: http://evekb.org/forum/viewtopic.php?f=503&t=18752

Btw: The linked thread is about an old database, the current rubicon 1.0.8 DB thread is here: viewtopic.php?f=503&t=21640

User avatar
Eowarebin
Greenhorn
Posts: 30
Joined: Thu Oct 03, 2013 00:13

Re: Multiple SQL Errors

Post by Eowarebin » Wed Jun 17, 2015 12:52

Very odd that you had the open-basedir issue on the KB. I have it running on a CentOS server with cpanel and have never had this issue before.

Post Reply

Return to “Support”

Who is online

Users browsing this forum: No registered users and 6 guests