#1
SMF 2.0.x Support / Updating problem
May 09, 2020, 08:00:41 AM by PD3...... (8) unsigned NOT NULL default '0', PRIMARY KEY (id_error), KEY log_time (log_time), KEY ............ (id_member), KEY ip (ip(16)) ) ENGINE=MyISAM; Ran the updater ............ and got this message: Incorrect date value: '0000-00-00' for column 'eventDate' ......
#2
SMF 2.0.x Support / Database error crashed site but why?
July 31, 2021, 07:31:40 AM by North East Man...... /index.php?action=profile;u=6461 Database Error: Incorrect key file for table './xxxxxx_smf766/ ......
#3
SMF 1.1.x Support / Error! 1075 upgrade 1.1.21 to 2.0.17
June 10, 2021, 02:35:29 PM by aswuser...... QuoteThe 1075 description is "ERROR 1075 (42000): Incorrect table definition; there can be only one auto ............ and it must be defined as a key". I would suggest doing a db export - structure ............ ). It looks like NONE of my tables has "PRIMARY KEY" defined. How do I fix that? I am not really ......
#4
Converting to SMF / Eblah 9.71 conversion issues
March 12, 2020, 01:24:30 PM by SimplyScripts...... an error: ++++++++++++ Converting members...Incorrect table definition; there can be only one auto ............ and it must be defined as a key ++++++++++++ Any help would be appreciated. ......
#5
SMF 2.0.x Support / Sessions table crashed
November 08, 2020, 05:30:14 PM by Sir Osis of Liver...... =sitemap;sa=topics;start=57200 Database Error: Incorrect key file for table './freeadzf_smf1/smf_sessions. ......
#6
SMF 2.0.x Support / Incorrect key file for table error
October 31, 2017, 08:15:45 AM by cardanocoins...... site is down. Now after 2 hours i got an error: Incorrect key file for table './cardanoc_DFG765DG/ ......
#7
Hilfe zu SMF (German) / Datenbankfehler bei Update auf 2.x.x
September 19, 2017, 03:19:25 PM by trix08...... der Tabellen folgende Fehlermeldung: QuoteERROR! Incorrect table definition; there can be only one auto ............ and it must bei defined as a key Siehe auch angehängtes Bild Nun bin ich leider ......
#8
SMF 2.0.x Support / Got error 127 when reading table './smf209/smf209_sessions'
November 03, 2015, 07:40:01 PM by aegersz...... 16:58:46 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './smf209/smf209_sessions.MYI'; ......
#9
SMF 2.0.x Support / Search index quirk: SQL error while changing post
September 06, 2015, 06:06:06 AM by perkele...... post: QuoteDuplicate entry '904057980-3242' for key 'PRIMARY' File: /var/www/vhosts/sangham.net/ ............ : Quote from: KindredThat message is actually incorrect. There have been no changes to the database since ............ there was an SQL error with a duplicate primary key entry somewhere, while editing an older post. ............ the removed words AND the added ones to avoid key constraints. if (!empty($removed_words)) { ............ , and both columns combined forming the primary key for this table. As I understand, this table ......
#10
SMF 2.0.x Support / Profile-View.php and posts made by
June 23, 2015, 05:27:42 PM by dekatria...... . This is the message I get QuoteDatabase Error Incorrect key file for table '/mysql-tmp/#sql_10a4_0.MYI'; ......
#11
SMF 2.0.x Support / Bunch of Error Messages
April 24, 2015, 05:40:37 PM by TheRealityBuzz...... a bunch of error messages all of a sudden. Incorrect key file for table './thereali_smf/smf_members. ......
#12
SMF 2.0.x Support / Ability for user to post breaks after while with database error
April 11, 2015, 08:27:36 AM by MortenMacFly...... ;start=45;board=18 [nonactive] Database Error: Incorrect key file for table './codeblo_smf/smf_messages. ............ ] Database Error: Duplicate entry '137658' for key 'PRIMARY' File: /srv/forums.codeblocks.org/ ......
#13
Install and Upgrade Help / Problems with Upgrade.php - Database related
March 16, 2015, 02:01:49 AM by natenkiki2004...... server version for the right syntax to use near 'key key varbinary(255) NOT NULL default ''' at line ............ Additional Functionality." (17 of 42) !!Error! Incorrect table definition; there can be only one auto ............ and it must be defined as a key I cannot find any information about what's going ......
#14
SMF 2.0.x Support / SMF 2.0.7 DATA BASE ERROR
June 08, 2014, 11:08:23 AM by babalola olasehinde...... any mod of recent, but my forum is showing Incorrect key file for table './seeker_smf1/smf_log_online. ......
#15
Italiano (Italian) / Errore del database
December 20, 2014, 05:59:32 AM by classemini...... forum viene segnalato un errore del database: Incorrect key file for table './classemini_SHL1/ ......
#16
SMF 2.0.x Support / Problem just started in version SMF 2.0 RC4
October 11, 2014, 06:26:39 AM by inkie...... on any content, this error message occurs: QuoteIncorrect key file for table './funkara_vitforum/ ......
#17
SMF 2.0.x Support / Weird Log-In Problems
August 15, 2014, 05:30:23 PM by James_L...... time. I thought previously I might have a sticky key on my keyboard or something. So I logged off and ............ in again. I entered my password very slowly, one key at a time, pressing each one firmly and ............ . "incorrect password." The second attempt -- I am in. I ............ I entered my password slowly and deliberately. "incorrect password." Second attempt -- I am in. After ............ my password. Same problem -- 1st attempt = "incorrect password." 2nd attempt = I am logged in. Clever ......
#18
YaBB/YaBB SE / Re: [SMF Converter] Yabb - 2.1
October 06, 2014, 12:26:05 PM by Bazie...... &array(1) { ["PRIMARY"]=> string(16) "DROP PRIMARY KEY" } [2]=> &string(0) "" [3]=> &array(1) { [" ............ /forum/Sources/DbPackages-mysql.php on line 534 Incorrect table name ''Any help on this? ......
#19
Modifications and Packages / Re: TinyPortal
February 10, 2023, 11:55:41 AM by @rjen...... 10, 2023, 11:34:31 AMAre you going to fix the incorrect display of the user avatar? I reported that the ............ would just deactivate the setting "Show group key on board index" and be done with it...I am not ......
#20
Install and Upgrade Help / Quickly upgrading a 1.08 to 2.04
October 05, 2013, 10:20:14 PM by Goodies...... - see above preparation (D) 2 == Error message: incorrect key file for table log_notify (or any other table. ......