Multiple SQL Errors

Help and support in getting the EVE-Dev Killboard to run on your site.
Johnny Skullchip
Greenhorn
Posts: 10
Joined: Sun Mar 11, 2012 03:36

Multiple SQL Errors

Post by Johnny Skullchip » Sun May 27, 2012 04:48

I just set up a fresh install. The url is: kb.eclipsenavy.ca

The first set of errors appears when I try to fetch killmails. I was able to fetch about 100 from eve-kill, but when I get to the most recent ones I get this error:
Database error: 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 '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 MySQL server version for the right syntax to use near 'and d.attributeID in (137,602)' at line 5
Error on line 46 in file /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbnormalquery.php
PHP 5.1.6 (Linux), EDK 4.0.4 (Crucible)
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.item.php, line: 152, class: DBNormalQuery, function: execute
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.idfeed.php, line: 806, class: Item, function: getSlot
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.idfeed.php, line: 556, class: IDFeed, function: processItem
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.idfeed.php, line: 485, class: IDFeed, function: processKill
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.idfeed.php, line: 138, class: IDFeed, function: processFeed
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/admin_idfeedsyndication.php, line: 155, class: IDFeed, function: read
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/admin_idfeedsyndication.php, line: 83, function: getIDFeed
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/index.php, line: 293, function: include
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/index.php, line: 27, function: include
The next thing is when I click the 'global options' menu under appearence in the admin panel. at the top of the page is this error:
WARNING [2] is_dir() [function.is-dir]: open_basedir restriction in effect. File(banner/..) is not within the allowed path(s): (/var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/:/tmp/)
Error on line 189 in file /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/option_appearance.php
PHP 5.1.6 (Linux), EDK 4.0.4 (Crucible)
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/option_appearance.php, line: 189, function: is_dir
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.options.php, line: 204, function: call_user_func
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.options.php, line: 162, class: options, function: assembleElement
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/admin.php, line: 18, class: options, function: genOptionsPage
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/index.php, line: 293, function: include
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/index.php, line: 27, function: include

WARNING [2] is_dir() [function.is-dir]: open_basedir restriction in effect. File(themes/..) is not within the allowed path(s): (/var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/:/tmp/)
Error on line 247 in file /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/option_appearance.php
PHP 5.1.6 (Linux), EDK 4.0.4 (Crucible)
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/option_appearance.php, line: 247, function: is_dir
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.options.php, line: 204, function: call_user_func
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.options.php, line: 162, class: options, function: assembleElement
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/admin/admin.php, line: 18, class: options, function: genOptionsPage
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/index.php, line: 293, function: include
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/index.php, line: 27, function: include
This next set of errors appears when I activate any module and go back to the home page of the killboard. Instead of showing the killboard homepage, there is just a white page with the following error:
WARNING [2] mysqli_query() [function.mysqli-query]: Empty query
Error on line 36 in file /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbnormalquery.php
PHP 5.1.6 (Linux), EDK 4.0.4 (Crucible)
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbnormalquery.php, line: 36, function: mysqli_query
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbquery.php, line: 26, function: call_user_func_array
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/mods/most_expensive_mod/most_expensive.php, line: 103, class: DBQuery, function: execute
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/mods/most_expensive_mod/init.php, line: 14, function: include_once
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.pageassembly.php, line: 80, function: call_user_func_array
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.pageassembly.php, line: 44, class: pageAssembly, function: call
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/home.php, line: 736, class: pageAssembly, function: assemble
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/index.php, line: 293, function: include
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/index.php, line: 27, function: include

Database error:
SQL:
ERROR [256] SQL error (
Error on line 46 in file /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbnormalquery.php
PHP 5.1.6 (Linux), EDK 4.0.4 (Crucible)
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.dbquery.php, line: 26, function: call_user_func_array
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/mods/most_expensive_mod/most_expensive.php, line: 103, class: DBQuery, function: execute
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/mods/most_expensive_mod/init.php, line: 14, function: include_once
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.pageassembly.php, line: 80, function: call_user_func_array
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/includes/class.pageassembly.php, line: 44, class: pageAssembly, function: call
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/home.php, line: 736, class: pageAssembly, function: assemble
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/common/index.php, line: 293, function: include
File: /var/www/vhosts/s15789001.onlinehome-server.info/httpdocs/kb/index.php, line: 27, function: include
I'm a bit confused why there errors are appearing. I think the error for fetching killmails might be due to the new killmail changes, but the other errors are confusing me since this is a fresh install.

Any help will be greatly appreciated.

Thanks

Johnny Skullchip
Greenhorn
Posts: 10
Joined: Sun Mar 11, 2012 03:36

Re: Multiple SQL Errors

Post by Johnny Skullchip » Sun May 27, 2012 05:12

OK, I was able to fix the error with fetching km's by updating to the new database, but I'm still having problems with the modding and appearance errors if anyone can shed some light.

User avatar
Salvoxia
Developer
Posts: 1518
Joined: Wed Feb 22, 2012 12:11

Re: Multiple SQL Errors

Post by Salvoxia » Sun May 27, 2012 09:39

The other errors point in the direction of an activated PHP safe mode setting. Try to disable safe mode in your php.ini.

User avatar
StinGer_ShoGuN
Apprentice
Posts: 67
Joined: Sat May 26, 2012 13:09
Location: Universe > Milky Way > Solar System > Earth > France > Paris
Contact:

Re: Multiple SQL Errors

Post by StinGer_ShoGuN » Sun May 27, 2012 11:37

About your first error, I had exactly the same a couple of days ago: I guess you are using memcache. Restart memcached and it will work.
Why drink and drike when you can smoke and fly ?
Pragmatic Kernel, c'est plus fort que toi !

alighieri
Greenhorn
Posts: 22
Joined: Sun May 27, 2012 11:56

Re: Multiple SQL Errors

Post by alighieri » Sun May 27, 2012 17:48

I've got the first error too
and don't have memcached

any Idea?

AndyM
Developer
Posts: 213
Joined: Thu Jul 16, 2009 21:44

Re: Multiple SQL Errors

Post by AndyM » Sun May 27, 2012 18:09

That error is generally associated with trying to pull older killmails i.e. mails generated before CCP started fucking around with item names.
You backed up your database, right ???

Johnny Skullchip
Greenhorn
Posts: 10
Joined: Sun Mar 11, 2012 03:36

Re: Multiple SQL Errors

Post by Johnny Skullchip » Sun May 27, 2012 19:40

I was finally able to fix the open_basedir restriction problems I was having. It wasn't safe mode in php.ini, it was plesk forcing open_basedir protection.

I was able to fix it by using this method: http://www.coderelic.com/2012/01/how-to ... -plesk-10/

Hope that helps anyone having the same problem.

But as far as the first error, I fixed it by upgrading my database to the new one released here for inferno.

Johnny Skullchip
Greenhorn
Posts: 10
Joined: Sun Mar 11, 2012 03:36

Re: Multiple SQL Errors

Post by Johnny Skullchip » Sun May 27, 2012 20:06

I'm still getting errors when trying to activate a certain module. since most of these issues have been resolved I will start a new thread regarding the mod errors.

User avatar
StinGer_ShoGuN
Apprentice
Posts: 67
Joined: Sat May 26, 2012 13:09
Location: Universe > Milky Way > Solar System > Earth > France > Paris
Contact:

Re: Multiple SQL Errors

Post by StinGer_ShoGuN » Tue May 29, 2012 16:43

alighieri wrote:I've got the first error too
and don't have memcached

any Idea?
Stupid idea but restart mysqld, restart the web server (if you can)... Not sure this will solve anything, but who knows...

Ho and other relevant question this time: have you updated your database ?
Why drink and drike when you can smoke and fly ?

Pragmatic Kernel, c'est plus fort que toi !

dbrummer
Noob
Posts: 6
Joined: Fri Dec 02, 2011 20:15

Re: Multiple SQL Errors

Post by dbrummer » Tue May 29, 2012 20:00

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

Post Reply

Return to “Support”

Who is online

Users browsing this forum: No registered users and 6 guests