Multiple SQL Errors

[Johnny Skullchip]

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]

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.

[Salvoxia]

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

[StinGer_ShoGuN]

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.

[alighieri]

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

any Idea?

[AndyM]

That error is generally associated with trying to pull older killmails i.e. mails generated before CCP started fucking around with item names.

[Johnny Skullchip]

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]

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.

[StinGer_ShoGuN]

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 ?

[dbrummer]

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