CMS Made Simple Forums

AmandaBTO wrote: I've just downloaded the full 1.4.1 so I could upgrade 1.2.1 (I think) to 1.4.1

I backed everything up, moved all the new files over and ran the upgrade (after chmod'ing config.php)

My template css associations is giving me this error:
Fatal error: Call to a member function on a non-object in /home/liquidwe/public_html/goemans/admin/listcssassoc.php on line 191

line 191 has:
$count = $result->RecordCount();
and result comes from a db execute of
$query = "SELECT assoc_css_id, css_name, assoc_order FROM ".cms_db_prefix()."css_assoc ca INNER JOIN ".cms_db_prefix()."css ON assoc_css_id = css_id WHERE assoc_type=? AND assoc_to_id = ? ORDER BY ca.assoc_order";

... WHERE assoc_type=? AND assoc_to_id = ?
Really?  This can't be right

AmandaBTO wrote: Yes I did but does the install/upgrade really modify the listcssassoc.php file?

sebjames wrote: I tried manually running the query as shown in listcssassoc.php line 181 and got this error:

Code: Select all

mysql> SELECT assoc_css_id, css_name, assoc_order FROM cms_css_assoc ca INNER JOIN cms_css ON assoc_css_id = css_id WHERE assoc_type=? AND assoc_to_id = ? ORDER BY ca.assoc_order;
ERROR 1064 (42000): 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 assoc_to_id = ? ORDER BY ca.assoc_order' at line 1

It does seem like there's something wrong with the listcssassoc.php file...

alby wrote: You must put valid data for ?
WHERE assoc_type=? AND assoc_to_id = ?

AmandaBTO wrote:

alby wrote: You must put valid data for ?
WHERE assoc_type=? AND assoc_to_id = ?

Yes, we know that.  The problem is that the core listcssassoc.php file doesn't have any values there.  The php file from the downloaded gz file only has question marks

 $query = "SELECT assoc_css_id, css_name, assoc_order FROM ".cms_db_prefix()."css_assoc ca INNER JOIN ".cms_db_prefix()."css ON assoc_css_id = css_id WHERE assoc_type=? AND assoc_to_id = ? ORDER BY ca.assoc_order";
  $result = $db->Execute($query, array($type, $id));