Support » Plugin: AWPCP - Classifieds Plugin » [Plugin: Another WordPress Classifieds Plugin] Sidebar Widget Posting too many ads

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author awpcp

    (@awpcp)

    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..

    Plugin Author awpcp

    (@awpcp)

    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:

    http://forum.awpcp.com

    Thanks, i have posted this on the main forum, my other site is also now down- but just on the sibebar http://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!

    Plugin Author awpcp

    (@awpcp)

    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.

    Plugin Author awpcp

    (@awpcp)

    @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.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘[Plugin: Another WordPress Classifieds Plugin] Sidebar Widget Posting too many ads’ is closed to new replies.