GD Star Rating Database Error
-
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 TABLEwp_gdsr_multisADD 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 TABLEwp_gdsr_multisCHANGEdescriptiondescriptiontext 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 TABLEwp_gdsr_multis_dataDROPreview
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 TABLEwp_gdsr_multis_dataDROPreview_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXidx_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 INDEXsource(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 INTOwp_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_templatesbefore 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
The topic ‘GD Star Rating Database Error’ is closed to new replies.