cPanel phpMyAdmin error #1366
Budget: $30 – $250 USD
When attempting to 'Import' a table called, "links" via .csv file into cPanel phpMyAdmin, I receive this error: Error
SQL query:
INSERT INTO `links` VALUES ('kid', 'cid', 'title', 'description', 'keywords', 'url', 'image', 'imagelinked', 'name', 'email', 'rating', 'votes', 'hits', 'premium', 'modified', 'newsubm', 'userid', 'urldate', 'subscribed', 'csuggest', 'cidsubm', 'subs_expire', 'lnkpassword', 'rev_no', 'extf2', 'extf3', 'extf4', 'street_cust', 'city_cust', 'phone_cust', 'context_cust', 'contextual_cust', 'address_cust', 'housingtype_cust', 'mapa_cust', 'mapb_cust', 'pslat_cust', 'pslon_cust', 'iauthor_cust', 'image1_cust', 'image2_cust', 'iauthorurl_cust', 'linkmap_cust', 'dPage_cust', 'st_cust', 'state_cust', 'zip_cust')
MySQL said: Documentation
#1366 - Incorrect integer value: 'kid' for column 'lnkid' at row 1
I have researched suggested solutions, but I am unable to fix this issue. If you can solve this issue in short order, I look forward to working with you.
SQL query:
INSERT INTO `links` VALUES ('kid', 'cid', 'title', 'description', 'keywords', 'url', 'image', 'imagelinked', 'name', 'email', 'rating', 'votes', 'hits', 'premium', 'modified', 'newsubm', 'userid', 'urldate', 'subscribed', 'csuggest', 'cidsubm', 'subs_expire', 'lnkpassword', 'rev_no', 'extf2', 'extf3', 'extf4', 'street_cust', 'city_cust', 'phone_cust', 'context_cust', 'contextual_cust', 'address_cust', 'housingtype_cust', 'mapa_cust', 'mapb_cust', 'pslat_cust', 'pslon_cust', 'iauthor_cust', 'image1_cust', 'image2_cust', 'iauthorurl_cust', 'linkmap_cust', 'dPage_cust', 'st_cust', 'state_cust', 'zip_cust')
MySQL said: Documentation
#1366 - Incorrect integer value: 'kid' for column 'lnkid' at row 1
I have researched suggested solutions, but I am unable to fix this issue. If you can solve this issue in short order, I look forward to working with you.