Ravens PHP Scripts: Forums
 

 
  Forum Index  •  Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in

Problems with indexes of table
 View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL
Author Message
kenwood
Worker
Worker



Joined: May 18, 2005
Posts: 119
Location: SVCDPlaza
PostPosted: Fri Dec 16, 2005 2:05 pm Reply with quote
If i check the tabels of mij database on the erser i have a lot of errors.
Is this a database error or is it the server his problem.
Code:



Problems with indexes of table `nuke_authors` 


 PRIMARY and INDEX keys should not both be set for column `aid` 


Problems with indexes of table `nuke_autonews` 


 PRIMARY and INDEX keys should not both be set for column `anid` 


Problems with indexes of table `nuke_banned_ip` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_banner` 


 PRIMARY and INDEX keys should not both be set for column `bid` 


Problems with indexes of table `nuke_bannerclient` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_bbsessions` 


 PRIMARY and INDEX keys should not both be set for column `session_id` 


Problems with indexes of table `nuke_blocks` 


 PRIMARY and INDEX keys should not both be set for column `bid` 


Problems with indexes of table `nuke_cnbya_field` 


 PRIMARY and INDEX keys should not both be set for column `fid` 


Problems with indexes of table `nuke_cnbya_value` 


 PRIMARY and INDEX keys should not both be set for column `vid` 


Problems with indexes of table `nuke_cnbya_value_temp` 


 PRIMARY and INDEX keys should not both be set for column `vid` 


Problems with indexes of table `nuke_comments` 


 PRIMARY and INDEX keys should not both be set for column `tid` 


Problems with indexes of table `nuke_downloads_categories` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_downloads_downloads` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_downloads_editorials` 


 PRIMARY and INDEX keys should not both be set for column `downloadid` 


Problems with indexes of table `nuke_downloads_modrequest` 


 PRIMARY and INDEX keys should not both be set for column `requestid` 


Problems with indexes of table `nuke_downloads_newdownload` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_downloads_votedata` 


 PRIMARY and INDEX keys should not both be set for column `ratingdbid` 


Problems with indexes of table `nuke_encyclopedia` 


 PRIMARY and INDEX keys should not both be set for column `eid` 


Problems with indexes of table `nuke_encyclopedia_text` 


 PRIMARY and INDEX keys should not both be set for column `tid` 


Problems with indexes of table `nuke_faqanswer` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_faqcategories` 


 PRIMARY and INDEX keys should not both be set for column `id_cat` 


Problems with indexes of table `nuke_headlines` 


 PRIMARY and INDEX keys should not both be set for column `hid` 


Problems with indexes of table `nuke_journal` 


 PRIMARY and INDEX keys should not both be set for column `jid` 


Problems with indexes of table `nuke_journal_comments` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_journal_stats` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_links_categories` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_links_editorials` 


 PRIMARY and INDEX keys should not both be set for column `linkid` 


Problems with indexes of table `nuke_links_links` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_links_modrequest` 


 PRIMARY and INDEX keys should not both be set for column `requestid` 


Problems with indexes of table `nuke_links_newlink` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_links_votedata` 


 PRIMARY and INDEX keys should not both be set for column `ratingdbid` 


Problems with indexes of table `nuke_message` 


 PRIMARY and INDEX keys should not both be set for column `mid` 


Problems with indexes of table `nuke_modules` 


 PRIMARY and INDEX keys should not both be set for column `mid` 


Problems with indexes of table `nuke_pages` 


 PRIMARY and INDEX keys should not both be set for column `pid` 


Problems with indexes of table `nuke_pages_categories` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_poll_desc` 


 PRIMARY and INDEX keys should not both be set for column `pollID` 


Problems with indexes of table `nuke_pollcomments` 


 PRIMARY and INDEX keys should not both be set for column `tid` 


Problems with indexes of table `nuke_public_messages` 


 PRIMARY and INDEX keys should not both be set for column `mid` 


Problems with indexes of table `nuke_queue` 


 PRIMARY and INDEX keys should not both be set for column `qid` 


Problems with indexes of table `nuke_quotes` 


 PRIMARY and INDEX keys should not both be set for column `qid` 


Problems with indexes of table `nuke_referer` 


 PRIMARY and INDEX keys should not both be set for column `rid` 


Problems with indexes of table `nuke_related` 


 PRIMARY and INDEX keys should not both be set for column `rid` 


Problems with indexes of table `nuke_reviews` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_reviews_add` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_reviews_comments` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_seccont` 


 PRIMARY and INDEX keys should not both be set for column `artid` 


Problems with indexes of table `nuke_sections` 


 PRIMARY and INDEX keys should not both be set for column `secid` 


Problems with indexes of table `nuke_stories` 


 PRIMARY and INDEX keys should not both be set for column `sid` 


Problems with indexes of table `nuke_stories_cat` 


 PRIMARY and INDEX keys should not both be set for column `catid` 


Problems with indexes of table `nuke_topics` 


 PRIMARY and INDEX keys should not both be set for column `topicid` 


Problems with indexes of table `nuke_users` 


 PRIMARY and INDEX keys should not both be set for column `user_id`

And i have a lot of There seems to be a problem with the MySQL server, sorry for the inconvenience. We should be back shortly.
The host tels me it is a problem with the site but when the server load is normal we have no problem.
 
View user's profile Send private message Visit poster's website
hitwalker
Sells PC To Pay For Divorce



Joined:
Posts: 5661
PostPosted: Fri Dec 16, 2005 3:35 pm Reply with quote
Is it a upgraded often database?
 
View user's profile Send private message
kenwood
PostPosted: Sat Dec 17, 2005 1:18 am Reply with quote
The database was phpnuke 7.4 i upgrade him to phpnuke 7.6 3.1.
But that was a while ago and on my home server ( suse 10.0 ) the same database give me no errors.
I upgrade the site and database on my home server and when that was done i upload the database and site to the host his server .
I am now for 2 months on this server and from te beginning i have those errors.
The host keep telling me its a database error that the site give me a lot of There seems to be a problem with the MySQL server, sorry for the inconvenience.
 
kenwood
PostPosted: Sat Dec 17, 2005 1:37 am Reply with quote
I have download rwsRavenNuke76_v1.05.00_FULL from this site and put the ravennuke_base.sql file in to a new database and the same problems white the same tabels.
The MySQL on the server is 4.0.26-standard
Code:



Problems with indexes of table `nuke_authors` 


 PRIMARY and INDEX keys should not both be set for column `aid` 


Problems with indexes of table `nuke_autonews` 


 PRIMARY and INDEX keys should not both be set for column `anid` 


Problems with indexes of table `nuke_banned_ip` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_banner` 


 PRIMARY and INDEX keys should not both be set for column `bid` 


Problems with indexes of table `nuke_bannerclient` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_bbsessions` 


 PRIMARY and INDEX keys should not both be set for column `session_id` 


Problems with indexes of table `nuke_blocks` 


 PRIMARY and INDEX keys should not both be set for column `bid` 


Problems with indexes of table `nuke_comments` 


 PRIMARY and INDEX keys should not both be set for column `tid` 


Problems with indexes of table `nuke_downloads_categories` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_downloads_downloads` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_downloads_editorials` 


 PRIMARY and INDEX keys should not both be set for column `downloadid` 


Problems with indexes of table `nuke_downloads_modrequest` 


 PRIMARY and INDEX keys should not both be set for column `requestid` 


Problems with indexes of table `nuke_downloads_newdownload` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_downloads_votedata` 


 PRIMARY and INDEX keys should not both be set for column `ratingdbid` 


Problems with indexes of table `nuke_encyclopedia` 


 PRIMARY and INDEX keys should not both be set for column `eid` 


Problems with indexes of table `nuke_encyclopedia_text` 


 PRIMARY and INDEX keys should not both be set for column `tid` 


Problems with indexes of table `nuke_faqanswer` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_faqcategories` 


 PRIMARY and INDEX keys should not both be set for column `id_cat` 


Problems with indexes of table `nuke_headlines` 


 PRIMARY and INDEX keys should not both be set for column `hid` 


Problems with indexes of table `nuke_journal` 


 PRIMARY and INDEX keys should not both be set for column `jid` 


Problems with indexes of table `nuke_journal_comments` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_journal_stats` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_links_categories` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_links_editorials` 


 PRIMARY and INDEX keys should not both be set for column `linkid` 


Problems with indexes of table `nuke_links_links` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_links_modrequest` 


 PRIMARY and INDEX keys should not both be set for column `requestid` 


Problems with indexes of table `nuke_links_newlink` 


 PRIMARY and INDEX keys should not both be set for column `lid` 


Problems with indexes of table `nuke_links_votedata` 


 PRIMARY and INDEX keys should not both be set for column `ratingdbid` 


Problems with indexes of table `nuke_message` 


 PRIMARY and INDEX keys should not both be set for column `mid` 


Problems with indexes of table `nuke_modules` 


 PRIMARY and INDEX keys should not both be set for column `mid` 


Problems with indexes of table `nuke_pages` 


 PRIMARY and INDEX keys should not both be set for column `pid` 


Problems with indexes of table `nuke_pages_categories` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_poll_desc` 


 PRIMARY and INDEX keys should not both be set for column `pollID` 


Problems with indexes of table `nuke_pollcomments` 


 PRIMARY and INDEX keys should not both be set for column `tid` 


Problems with indexes of table `nuke_public_messages` 


 PRIMARY and INDEX keys should not both be set for column `mid` 


Problems with indexes of table `nuke_queue` 


 PRIMARY and INDEX keys should not both be set for column `qid` 


Problems with indexes of table `nuke_quotes` 


 PRIMARY and INDEX keys should not both be set for column `qid` 


Problems with indexes of table `nuke_referer` 


 PRIMARY and INDEX keys should not both be set for column `rid` 


Problems with indexes of table `nuke_related` 


 PRIMARY and INDEX keys should not both be set for column `rid` 


Problems with indexes of table `nuke_reviews` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_reviews_add` 


 PRIMARY and INDEX keys should not both be set for column `id` 


Problems with indexes of table `nuke_reviews_comments` 


 PRIMARY and INDEX keys should not both be set for column `cid` 


Problems with indexes of table `nuke_stories` 


 PRIMARY and INDEX keys should not both be set for column `sid` 


Problems with indexes of table `nuke_stories_cat` 


 PRIMARY and INDEX keys should not both be set for column `catid` 


Problems with indexes of table `nuke_topics` 


 PRIMARY and INDEX keys should not both be set for column `topicid` 


Problems with indexes of table `nuke_users` 


 PRIMARY and INDEX keys should not both be set for column `user_id`
 
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088
PostPosted: Sat Dec 17, 2005 1:53 am Reply with quote
Those are not problems. It's just a notification of a standards violation, if you will. Once again, poor design by FB. he doesn't understand SQL either. Maybe I'll just clean those up in my next release Wink

As to your other issue, if running a Repair on your tables doesn't clear it up then it's a 99% positive that it's your MySQL server - in other words your host.
 
View user's profile Send private message
kenwood
PostPosted: Sat Dec 17, 2005 2:09 am Reply with quote
If i do a repair on the tables there are no problems .
So i think a look for a other host for my site .
Thanxs you both for the comments.
 
Raven
PostPosted: Sat Dec 17, 2005 2:27 am Reply with quote
Look no further -> RavensScripts
 
kenwood
PostPosted: Sat Dec 17, 2005 2:30 am Reply with quote
I wil send you a link where you can see mij stats for the month dec. notis that the last 3 dags my site is closet du the sql errors.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL


 Jump to:   




View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©