• Resolved ganesh.india

    (@ganeshindia)


    i hosted my website on localhost of vesion 2.8.3 and from the version 1.5.2 i m getting the error

    WordPress database error Unknown table ‘wp_gdsr_data_multi’ for query drop table wp_gdsr_data_multi
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->delete_tables
    WordPress database error Unknown table ‘wp_multis_trend’ for query drop table wp_multis_trend
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->delete_tables
    WordPress database error Multiple primary key defined for query ALTER TABLE wp_gdsr_multis ADD PRIMARY KEY (multi_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error BLOB/TEXT column ‘description’ can’t have a default value for query ALTER TABLE wp_gdsr_multis CHANGE description description text NOT NULL default ”
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Can’t DROP ‘review’; check that column/key exists for query ALTER TABLE wp_gdsr_multis_data DROP review
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Can’t DROP ‘review_text’; check that column/key exists for query ALTER TABLE wp_gdsr_multis_data DROP review_text
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_id_log’ for query ALTER TABLE wp_gdsr_votes_log ADD INDEX idx_id_log (id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_vote_log’ for query ALTER TABLE wp_gdsr_votes_log ADD INDEX idx_vote_log (vote_type)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_multi_log’ for query ALTER TABLE wp_gdsr_votes_log ADD INDEX idx_multi_log (multi_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_user_log’ for query ALTER TABLE wp_gdsr_votes_log ADD INDEX idx_user_log (user_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_id_trd’ for query ALTER TABLE wp_gdsr_votes_trend ADD INDEX idx_id_trd (id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_vote_trd’ for query ALTER TABLE wp_gdsr_votes_trend ADD INDEX idx_vote_trd (vote_type)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_section_tpl’ for query ALTER TABLE wp_gdsr_templates ADD INDEX idx_section_tpl (section)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_id_mod’ for query ALTER TABLE wp_gdsr_moderate ADD INDEX idx_id_mod (id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_vote_mod’ for query ALTER TABLE wp_gdsr_moderate ADD INDEX idx_vote_mod (vote_type)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_multi_mod’ for query ALTER TABLE wp_gdsr_moderate ADD INDEX idx_multi_mod (multi_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_user_mod’ for query ALTER TABLE wp_gdsr_moderate ADD INDEX idx_user_mod (user_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_post_mdt’ for query ALTER TABLE wp_gdsr_multis_data ADD INDEX idx_post_mdt (post_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_multi_mdt’ for query ALTER TABLE wp_gdsr_multis_data ADD INDEX idx_multi_mdt (multi_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_post_mtt’ for query ALTER TABLE wp_gdsr_multis_trend ADD INDEX idx_post_mtt (post_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘idx_multi_mtt’ for query ALTER TABLE wp_gdsr_multis_trend ADD INDEX idx_multi_mtt (multi_id)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Duplicate key name ‘source’ for query ALTER TABLE wp_gdsr_multis_values ADD INDEX source (source)
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
    WordPress database error Column count doesn’t match value count at row 1 for query INSERT INTO wp_gdsr_templates (section, name, description, elements, dependencies, preinstalled, default) VALUES(‘Alternative Widget Blog Rating’, ”, ‘a:1:{s:6:”normal”;s:262:”<p class="trw-title">Average rating:</p><p class="trw-rating">%RATING%</p><p class="trw-footer">%VOTES% %WORD_VOTES% for %COUNT% posts</p>”;}’, ”, ‘2’, ‘0’);
    made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, GDSRDB->install_all_templates, GDSRDB->insert_extras_templates
    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query update wp_gdsr_templates set dependencies = ‘a:1:{s:3:”EWV”;s:1:”1″;}’ where template_id = made by activate_plugin, include, GDStarRating->GDStarRating, GDStarRating->install_plugin, GDSRDB->install_all_templates, GDSRDB->insert_extras_templates

    before 1.5.2 version everthing is alright, when i click on active then i get the above error and plugin get activated, but then also i cannot configure a single setting bcz i get the same error….everywhere. What should i do?

    At this time i m using GD Star Rating 1.6.0

Viewing 2 replies - 1 through 2 (of 2 total)
  • This is not a bug at all. Your server is set to report even the things that normally should be reported, and all this is standard upgrade procedure trying to upgrade older versions of the database. So, you can ignore all of this. This happens only once, when the upgrade or install is performed.

    Thread Starter ganesh.india

    (@ganeshindia)

    i m not upgrading anything….i just click on activate…then all this happen.

    One more thing whenever i m try to configure or click on anyone of the GD Star Rating Tab, i am getting error like this…

    Error Summary
    HTTP Error 500.0 – Internal Server Error
    C:\Program Files (x86)\PHP\php-cgi.exe – The FastCGI process exited unexpectedly

    Detailed Error Information
    Module FastCgiModule
    Notification ExecuteRequestHandler
    Handler PHP_via_FastCGI
    Error Code 0x000000ff
    Requested URL http://localhost:80/blog/wp-admin/admin.php?page=gd-star-rating/gd-star-rating.php
    Physical Path C:\Users\[Username]\blog\wp-admin\admin.php
    Logon Method Anonymous
    Logon User Anonymous

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘GD Star Rating Database Error’ is closed to new replies.