21
Is it an upgrade or fresh install ?
Wich config (xoops, php, server) ?
For test, can you add in class/ads.php the 4 lines echo and post the result ?
{Edit]
If the query is displayed, try to copy and paste this query in phpmyadmin.
Wich config (xoops, php, server) ?
For test, can you add in class/ads.php the 4 lines echo and post the result ?
function insert(&$ads)
{
if (get_class($ads) != 'CatadsAds') {
echo "Error 1 ";
return false;
}
if (!$ads->cleanVars()) {
echo "Error 2 ";
return false;
}
foreach ($ads->cleanVars as $k => $v) {
${$k} = $v;
}
if (empty($ads_id)) {
$ads_id = $this->db->genId('catads_ads_ads_id_seq');
$sql = 'INSERT INTO '.$this->db->prefix('catads_ads').' (ads_id, cat_id, ads_title, ads_type, ads_desc, price, monnaie, price_option, email, uid, phone, town, codpost, created, published, expired, photo, view, notify_pub, poster_ip, contact_mode, countpub, suspend, waiting) VALUES ('.$ads_id.', '.$cat_id.', '.$this->db->quoteString($ads_title).', '.$this->db->quoteString($ads_type).', '.$this->db->quoteString($ads_desc).', '.$price.', '.$this->db->quoteString($monnaie).', '.$this->db->quoteString($price_option).', '.$this->db->quoteString($email).', '.$uid.', '.$this->db->quoteString($phone).', '.$this->db->quoteString($town).', '.$this->db->quoteString($codpost).', '.$created.', '.$published.', '.$expired.', '.$this->db->quoteString($photo).', '.$view.', '.$notify_pub.', '.$this->db->quoteString($poster_ip).', '.$contact_mode.', '.$countpub.', '.$suspend.', '.$waiting.')';
} else {
$sql = 'UPDATE '.$this->db->prefix('catads_ads').' SET cat_id='.$cat_id.', ads_title='.$this->db->quoteString($ads_title).', ads_type='.$this->db->quoteString($ads_type).', ads_desc='.$this->db->quoteString($ads_desc).', price='.$price.', monnaie='.$this->db->quoteString($monnaie).', price_option='.$this->db->quoteString($price_option).', email='.$this->db->quoteString($email).', uid='.$uid.', phone='.$this->db->quoteString($phone).', town='.$this->db->quoteString($town).', codpost='.$this->db->quoteString($codpost).', created='.$created.', published='.$published.', expired='.$expired.', photo='.$this->db->quoteString($photo).', view='.$view.', notify_pub = '.$notify_pub.', poster_ip='.$this->db->quoteString($poster_ip).', contact_mode='.$contact_mode.', countpub='.$countpub.', suspend='.$suspend.', waiting='.$waiting.' WHERE ads_id='.$ads_id;
}
if (!$result = $this->db->queryF($sql)) {
echo $sql."";
echo "Error 3 ";
return false;
}
if (empty($ads_id)) {
$ads_id = $this->db->getInsertId();
}
$ads->assignVar('ads_id', $ads_id);
return $ads_id;
} {Edit]
If the query is displayed, try to copy and paste this query in phpmyadmin.
).
