[Plugin: Another WordPress Classifieds Plugin] Sidebar Widget Posting too many ads

Yep, this seems to be a bug in the latest version. We’re looking into it ASAP. Thanks for letting me know.

Hi, my all in one classifieds competely crashed, the side bar wasn’t working so i re installed it, now it comes up with this..WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD is_featured_ad tinyint(1) DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD posterip varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD flagged tinyint(1) DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD disabled_date datetime DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD websiteurl VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER ad_contact_email

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads DROP INDEX titdes

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD FULLTEXT KEY titdes (ad_title,ad_details)

AWPCP SQL Error Errno: [256] SQLError:(145) Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired
Query : ALTER TABLE wp_awpcp_ads ADD ad_fee_paid float(7,2) NOT NULL AFTER adterm_id
Called by line 562 in file /index.php, error in /home/allthing/public_html/wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.php at line 27, PHP 5.2.17 (Linux)
Aborting…

please let me know also when you get it fixed.

Thanks..

Hi equinestaff,

That particular issue requires you or someone that maintains your website to repair the wp_awpcp_ads table. That’s not something the plugin can fix per se.

You’re the first report of that particular issue. If you can post it in the main support forum, we can explore this further:

https://forum.awpcp.com

Thanks, i have posted this on the main forum, my other site is also now down- but just on the sibebar https://www.horseandponyads.com.au/

AWPCP SQL Error Errno: [256] SQLError:(145) Table ‘./horseau_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired
Query : SELECT count(*) FROM wp_awpcp_ads
Called by line 318 in file /index.php, error in /home/horseau/public_html/wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.php at line 29, PHP 5.2.17 (Linux)
Aborting…

not sure if this is the same issue or not.

@wpelliott: have you tried OSClass? It’s not WordPress based, but it’s very similar and easy to use. Furthermore, it’s for classifieds only!

Bug is patched. Please download 2.0.5.

No luck when i downloaded it come up with

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD is_featured_ad tinyint(1) DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD posterip varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD flagged tinyint(1) DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD disabled_date datetime DEFAULT NULL

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD websiteurl VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER ad_contact_email

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads DROP INDEX titdes

WordPress database error: [Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired]
ALTER TABLE wp_awpcp_ads ADD FULLTEXT KEY titdes (ad_title,ad_details)
AWPCP SQL Error Errno: [256] SQLError:(145) Table ‘./allthing_wrdp1/wp_awpcp_ads’ is marked as crashed and should be repaired
Query : ALTER TABLE wp_awpcp_ads ADD ad_fee_paid float(7,2) NOT NULL AFTER adterm_id
Called by line 556 in file /wp-admin/plugins.php, error in /home/allthing/public_html/wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.php at line 27, PHP 5.2.17 (Linux)
Aborting…

Works great! Thanks for getting the patch done.

@WPElliot: Good news. ??

@equinestaff: As I mentioned above, you need to repair the tables in phpMyAdmin or your favorite MySQL tool FIRST. Those errors won’t disappear on upgrade until you do.

Your other option if this is a NEW install only, delete the tables and reinstall AWPCP.

Thank you, i have now fixed it.

From my experience with AWPCP, heavy modification can crash the software, so becareful what you modify and again make sure you upgrade to the latest wordpress.