Pagina 1 din 1

erori in mysql

Scris: 11-Aug-2009, 06:59:50
de opo
am urmatoarele erori

Cod: Selectaţi tot

PRIMARY and INDEX keys should not both be set for column `post_id`
More than one INDEX key was created for column `topic_id`
More than one FULLTEXT key was created for column `poster_ip`
More than one INDEX key was created for column `enable_sig`
More than one INDEX key was created for column `post_time`
More than one FULLTEXT key was created for column `post_subject`
la urmatoarea stuctura de indexi

Cod: Selectaţi tot

Indexes: Documentation Keyname 	Type 	Cardinality 	Action 	Field
PRIMARY 	PRIMARY 	773  	EditEdit 	DropDrop 	post_id
forum_id 	INDEX 	None  	EditEdit 	DropDrop 	forum_id
topic_id 	INDEX 	None  	EditEdit 	DropDrop 	topic_id
poster_ip 	INDEX 	None  	EditEdit 	DropDrop 	poster_ip
poster_id 	INDEX 	None  	EditEdit 	DropDrop 	poster_id
post_approved 	INDEX 	None  	EditEdit 	DropDrop 	post_approved
tid_post_time 	INDEX 	None  	EditEdit 	DropDrop 	topic_id
post_time
enable_sig 	INDEX 	None  	EditEdit 	DropDrop 	enable_sig
enable_sig_2 	INDEX 	None  	EditEdit 	DropDrop 	enable_sig
enable_sig_3 	INDEX 	None  	EditEdit 	DropDrop 	enable_sig
post_id 	INDEX 	None  	EditEdit 	DropDrop 	post_id
post_time 	INDEX 	None  	EditEdit 	DropDrop 	post_time
post_time_2 	INDEX 	None  	EditEdit 	DropDrop 	post_time
poster_ip_2 	FULLTEXT 	None  	EditEdit 	DropDrop 	poster_ip
poster_ip_3 	FULLTEXT 	None  	EditEdit 	DropDrop 	poster_ip
post_subject 	FULLTEXT 	None  	EditEdit 	DropDrop 	post_subject
post_text 	FULLTEXT 	None  	EditEdit 	DropDrop 	post_text
post_content 	FULLTEXT 	None  	EditEdit 	DropDrop 	post_subject
post_text 
Nu inteleg care e problema ca urmare nici cum o pot rezolva.

Re: eroori in mysql

Scris: 11-Aug-2009, 23:54:49
de bogdan
Ce incerci sa faci? Cand apare eroarea?

viewtopic.php?f=14&t=15139&p=109011#p109011

Re: eroori in mysql

Scris: 12-Aug-2009, 06:08:35
de opo
Forumul nu imi da nici o erooare. Voiam sa instalez Automatic backup si am intrat in PhpMyadmin sa fac backup la baza de date inainte; si cand ma uit la campul posts vad respectivele eroori. Din punct de vedere al forumului nu am nici un side-efect, dar banui ca daca MySql zice ca ceva nu-i bine atunci ar trebui sa corectez greselile dn bd, nu as vrea in viitor sa am surprize.

phpbb 3.05
PHP Version 5.2.1
MySQL Version 5.0.77
mod-urile instalate pana acum
-advance quick reply
-Ajax quick edit
-Ajax Chat
-Mark edit posts as unread
-NV recent topics
-NV who was here
forumul instalat de mine direct 3.05
Nu e nevoie de cont de test problema nu e pe forum, forumul merge fara probeme

Mulumesc

Re: eroori in mysql

Scris: 12-Aug-2009, 18:44:31
de bogdan
Cred ca nu e vorba de erori ci de avertizari (warning).

Daca ai 2 indecsi creati pe aceeasi coloana, acestia vor consuma spatiu si timp pentru a fi actualizati. Poti sterge unul din ei daca nu e folosit (nu e complicat)

Daca nu ai un volum mare de date (milioane de inregistrari) ii poti lasa asa cum sunt acum.