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 ?
le="color: #000000"><?php function insert(&$ads) { if (get_class($ads) != 'CatadsAds') { echo "Error 1 </ br>"; return false; } if (!$ads->cleanVars()) { echo "Error 2 </ br>"; 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."</ br>"; echo "Error 3 </ br>"; 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.
).
