victorjonsson / Arlima

Article List Manager - Wordpress plugin suitable for online newspapers that's in need of a fully customizable front page
28 stars 16 forks source link

Multisite issue #9

Closed donmatthew closed 10 years ago

donmatthew commented 11 years ago

Fatal error: Uncaught exception 'Exception' with message 'Table 'xxx_wp297.wp_2_arlima_articlelist' doesn't exist' in /home/xxx/public_html/wp-content/plugins/arlima/classes/ListFactory.php:390 Stack trace: #0 /home/xxx/public_html/wp-content/plugins/arlima/classes/ListFactory.php(573): Arlima_ListFactory->executeSQLQuery('get_results', 'SELECT alid, a...', 'al', true) #1 /home/xxx/public_html/wp-content/plugins/arlima/classes/Plugin.php(148): Arlima_ListFactory->loadListSlugs() #2 [internal function]: Arlima_Plugin->adminBar('') #3 /home/xxx/public_html/wp-includes/plugin.php(406): call_user_func_array(Array, Array) #4 /home/xxx/public_html/wp-includes/admin-bar.php(60): do_action('wp_before_admin...') #5 [internal function]: wp_admin_bar_render('') #6 /home/xxx/public_html/wp-includes/plugin.php(406): call_user_func_array('wp_admin_bar_re...', Array) #7 /home/xxx/public_html/wp-admin/admin-header.php(113): do_action('in_admin_header') #8 /home/xxx/public_html/wp-admin/theme in /home/xxx/public_html/wp-content/plugins/arlima/classes/ListFactory.php on line 390

Solved this one by creating an empty table named wp_2_arlima_articlelist etcetera for each sub site. Not sure if this appeared during the previous upgrade or the latest one (2.6)

victorjonsson commented 11 years ago

Arlima has not been tested on a mu installation. It looks as if you have installed the plugin site wide (from the main blog) but then tried to update the plugin from a sub blog. Is this the case?

Anyhow, this should be looked into...

donmatthew commented 11 years ago

nope, regular network admin update.. maybe you could check if there's sub blogs available and in that case create an empty table. I've also seen plug-ins asking if you want to update plugin for network or not.

victorjonsson commented 11 years ago

Okey... In case we're on a multisite Arlima has to:

Arlima does not have this logic, so at this moment the plugin does not support multi sites.

donmatthew commented 11 years ago

I got this working for now by running this SQL statement. Notice the $key variable which should be changed to the blog ID or ID:s.

CREATE TABLE IF NOT EXISTS wp_$key_arlima_articlelist ( al_id mediumint(9) NOT NULL AUTO_INCREMENT, al_created bigint(11) NOT NULL DEFAULT '0', al_title tinytext NOT NULL, al_slug varchar(50) DEFAULT NULL, al_options text, al_maxlength mediumint(9) NOT NULL DEFAULT '100', PRIMARY KEY (al_id), UNIQUE KEY id (al_id), KEY created (al_created), KEY slug (al_slug) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

chredd commented 10 years ago

This is solved in 3.0+. Closing issue.