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:

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
> 
> > … 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]
> 
> This is definitely the entries table ([link=https://mylittleforum.net/forum/index.php?id=12309]as I assumed[/link]). There was the column [inlinecode]email_notification[/inlinecode] up to the version 2.4.13. With the new structure to store subscriptions, introduced with 2.4.14 the column got removed but it still existed in the backup script. It is there [i]only[/i] in the INSERT-statements for the restore that does not contain a column list. Default behaviour of MySQL in this case is to try to distribute the given data to all of the columns but the number of provided data columns in the INSERT-statement does not fit with the real number of table columns (valid for version installed [i]before 2.4.14[/i] and updated to version 2.4.14 or higher).
> 
> Additionally I found the column [inlinecode]email_notification[/inlinecode] in the installation script. If the forum was installed with a newer version than 2.4.13 the column was created but never used. If one created a backup and restored it, the number of columns in the statements and in the table matched. With a version that was installed [i]before[/i] 2.4.14 and where the update script removed the column with the update to 2.4.14 the number of columns [i]does not match[/i] in case of restoring a backup.
> 
> I reworked the whole backup script.
> 
> - The statement strings that will be created by the script will from now on contain a field/column list in every statement. With that one can compare the number of table columns with the number of data fields if one can read SQL-code.
> - I added backup functions for subscriptions and for tags.
> - I corrected the statement for the entries and removed the column [inlinecode]email_notification[/inlinecode] in the end.
> - I put a bit of work into the determination of the file sizes of the backup files after seeing file sizes of 0.000MB for files with under 1 Kilobyte of data.
> 
> I will release a new version (2.4.22) within the next two days (until thursday evening (CEST)).
> 
> Tschö, Auge

E-mail notification on reply of this posting