[For 1.6] Advanced Sidebox 2.1.1

[JimR]

I have a problem that I can not track down in the source code.
I have tried the following

1. Created a new database
   
2. granted the user all privs to the database
   
3. installed a new copy of mybb
   
4. copied the files for asb 2.0.7 to the correct places
   

but I still get the following error

SQL 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 '1612' at line 2
Query:
SHOW TABLES FROM 1612

I did some digging around and found this in installer.php

private function build_table_list()
	{
		global $config;

		$query = $this->db->write_query("
			SHOW TABLES
			FROM {$config['database']['database']}
		");

		$table_list = array();
		while ($row = $this->db->fetch_array($query)) {
			$table_list[array_pop($row)] = 1;
		}
		return $table_list;
	}

which appears to be the offending code however it looks correct any ideas ?

---

I found the error .... this code works

private function build_table_list()
	{
		global $config;

		$query = $this->db->write_query("
			SHOW TABLES
			FROM `{$config['database']['database']}`
		");

		$table_list = array();
		while ($row = $this->db->fetch_array($query)) {
			$table_list[array_pop($row)] = 1;
		}
		return $table_list;
	}

notice the ` 's in the code ... this may be worth trying on other sql versions the original code failed on

Apache/2.4.6 (Ubuntu)
Database client version: libmysql - 5.5.35
PHP extension: mysqli

---

I am now getting this with my acp style
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1255 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1255 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1257 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1257 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1258 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1258 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1260 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1260 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1261 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1261 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1263 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1263 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 590 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 590 errorHandler->error
/inc/plugins/asb/acp.php 1265 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Warning [2] Illegal string offset 'id' - Line: 593 - File: admin/styles/ProjectX/style.php PHP 5.5.3-1ubuntu2.3 (Linux)
File Line Function
/admin/styles/ProjectX/style.php 593 errorHandler->error
/inc/plugins/asb/acp.php 1265 FormContainer->output_row
/inc/plugins/asb/acp.php 69 asb_admin_manage_scripts
/inc/class_plugins.php 101 asb_admin
/admin/index.php 570 pluginSystem->run_hooks
Add
Title:

the display name
Filename:

the file name of the script
Action:

the URL action value
Page

the URL page value
Left Width

width of left column in pixels
Right Width

width of right column in pixels
Output Sideboxes To Variables Rather Than Editing Templates?
use this option if the script does not use templates to output the side box columns as $asb_left and $asb_right
Template:

name of the template to edit
Hook:

plugin hook to use
Header Search Text

ASB will place the side box tables just after the contents of this setting are found
Footer Search Text

ASB will place the side box tables just before the contents of this setting are found
Replacing entire template?
set to yes in order to replace the entire template with custom content

as stated before this is the only plugin causing this error and the error seems to jump from one function to another on asb plugin updates, I guess I will have to keep patching my themes style.php

---

I get this jscript error also



where would I find this in the code ?

also notice the 2 css differences ... i.e the navigation being shaded and the selected element having a background