Post reply

Reply to the message by shian

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:

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:

> Thank you.
> 
> [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]
> 
> 
> [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 */;
> 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 */;
> 
> --
> -- Dumping data for table `mlf2_temp_infos`
> --
> 
> 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]
> 
> 
> [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]
> 
> 
> it's getting interesting... BTW - The 'Restore' simply erased all entries in my Forum! :-| 
> 
> Thank you, shian.

E-mail notification on reply of this posting