View Full Version : Remote ad 2.0.2 : table "multi_formats" does not exist

Jean-francois Bernard
March 2, 2013, 05:22 PM

Just to inform you: The table "multi_formats" does not exist in the database,
PS: I don't really understand this SQL, I don't have multifield installed, remote ad did not work, I had to comment this test in order to use Remote ad.

RemoteAdverts.class.php line 172

if( $this -> getOne("SELECT `Key` FROM `".RL_DBPREFIX."plugins` WHERE `Status` = 'active' AND `Key` = 'multiField'") )
$sql = "SELECT * FROM `".RL_DBPREFIX."multi_formats` WHERE 1 ";
global $multi_formats;
$mf_tmp = $this -> getAll( $sql );
foreach( $mf_tmp as $key => $item )
$multi_formats[ $item['Key'] ] = $item;

Morgan Bohman
March 2, 2013, 06:23 PM
Jean, you should only get a result into $item if there's a multifield inside the key, if not it will skip it so maybe there's another error. Works fine for me. BTW all code should be inside tags so non-registered can not view and copy.

Have a nice evening!