« Project home page
my little forum
Log in
Register
Search:
Back to the entry by Auge
Post reply
Reply to the message by
Auge
Name:
E-mail:
(optional, won't be displayed directly)
Leave this field empty:
Homepage:
(optional)
Leave this field empty:
Location:
(optional)
Remember me (cookie)
Category:
General
Project organisation
Technics
Design/Themes
Features
Development
Todo
Bugs
German / Deutsch
Spanish / Español
French / Français
Accessibility/UX
Subject:
Formatting help
skip to input
format text bold
[b]bold text[/b]
format text italic
[i]italic text[/i]
insert hyperlink
[link=http://example.com/]link text[/link] / [link]http://example.com/[/link]
set text color
[color=#rgb]colored text[/color]
font size
[size=small]small text[/size]
[size=large]large text[/size]
insert list
[list][*]list item[/list]
insert image
[img]http://example.com/image.jpg[/img]
left: [img=left]http://example.com/image.jpg[/img]
right: [img=right]http://example.com/image.jpg[/img]
thumbnail: [img=thumbnail]http://example.com/image.jpg[/img]
thumbnail left: [img=thumbnail-left]http://example.com/image.jpg[/img]
thumbnail right: [img=thumbnail-right]http://example.com/image.jpg[/img]
upload image
upload image ...
insert TeX code
[tex]TeX code[/tex]
insert code
[inlinecode]code[/inlinecode]
[code]code[/code]
[code=css]code[/code]
[code=html]code[/code]
[code=javascript]code[/code]
[code=perl]code[/code]
[code=php]code[/code]
[code=sql]code[/code]
[code=xml]code[/code]
:-)
;-)
:-P
:-D
:-|
:-(
:yes:
:no:
:ok:
:lol:
:lol2:
:lol3:
:cool:
:surprised:
:angry:
:crying:
:waving:
:confused:
:lookaround:
:clap:
:love:
:tick:
Message:
> Hello > > This is getting confuse. > > > [i]This is the entry in my last backup of my little forum, using the [b]'Backup' feature[/b]:[/i] > > [code=sql]# > > # mlf2_temp_infos > > # > > TRUNCATE TABLE mlf2_temp_infos; > > INSERT INTO mlf2_temp_infos VALUES ('last_changes', '1598868462', '2020-08-31 13:07:42'); > > [/code] > > Ok, there is only [i]this [b]one[/b][/i] entry ('last_changes', '1598868462', '2020-08-31 13:07:42') in the table [inlinecode]mlf2_temp_infos[/inlinecode]? No entry for the version number? No entry for the latest version check? > > > [i]And this is the entry in my last backup of my little forum, using the [b]server's cpanel[/b]:[/i] > > [code=sql]-- > > -- Table structure for table `mlf2_temp_infos` > > -- > > > > DROP TABLE IF EXISTS `mlf2_temp_infos`; > > /*!40101 SET @saved_cs_client = @@character_set_client */; > > /*!40101 SET character_set_client = utf8 */; > > [/code] > > Delete an possibly existing table of the name [inlinecode]mlf2_temp_infos[/inlinecode]. > > > [code=sql] > > CREATE TABLE `mlf2_temp_infos` ( > > `name` varchar(50) NOT NULL, > > `value` varchar(255) NOT NULL, > > `time` timestamp NULL DEFAULT NULL, > > PRIMARY KEY (`name`) > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > /*!40101 SET character_set_client = @saved_cs_client */; > > [/code] > > That's the same create statement than the one from the installation script. > > > [code=sql] > > LOCK TABLES `mlf2_temp_infos` WRITE; > > /*!40000 ALTER TABLE `mlf2_temp_infos` DISABLE KEYS */; > > INSERT INTO `mlf2_temp_infos` (`name`, `value`, `time`) VALUES ('last_changes','1598868462','2020-08-31 10:07:42'); > > /*!40000 ALTER TABLE `mlf2_temp_infos` ENABLE KEYS */; > > UNLOCK TABLES; > > [/code] > > Ok, the one dataset from above ('last_changes','1598868462','2020-08-31 10:07:42', the ony difference is the time (zone)) seems to be really the only entry in the table. So far so good (but disturbing). > > > [i][b]It looks OK[/b]. So I tried to restore again using [b]my little forum 'Restore'[/b], and I got a new error![/i] :-D : > > [code]Error! > > > > MySQL error: Column count doesn't match value count at row 1 > > [/code] > > Oh, that is definitely another statement. Because the forum entries are gone I guess it's the statement for the table [inlinecode]mlf2_entries[/inlinecode]. The statement for the table [inlinecode]mlf2_temp_infos[/inlinecode] [i]implicitely[/i] specifies three columns (with not naming them, there are only three columns in the table (`name`, `value`, `time`)) and provides data for three columns ('last_changes', '1598868462', '2020-08-31 13:07:42'). > > > it's getting interesting... BTW - The 'Restore' simply erased all entries in my Forum! :-| > > :-( I hope, you have a [i]working[/i] backup and did the tests in a non productive copy of your real forum. I will definitely dig into it. > > Tschö, Auge
E-mail notification on reply of this posting
OK - Submit
Preview