Forum - Geeklog

Welcome to Geeklog Sunday, April 22 2018 @ 10:07 pm EDT

upgrade issues fom 1.8.2sr1 to 2.0.0

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript perl php plain python	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: Habitual[/u][p]Almost there!

3 Alter statements to the 1.8.1 db:[code]
ALTER TABLE `dorkblog`.`gl_sessions` 
ADD COLUMN `whos_online` TINYINT(1) NOT NULL DEFAULT '1',
ADD COLUMN `topic` VARCHAR(20) NOT NULL AFTER `whos_online`;
...
ALTER TABLE `dorkblog`.`gl_topics`
ADD COLUMN `parent_id` varchar(20) NOT NULL default 'root',
ADD COLUMN `inherit` tinyint(1) NOT NULL default '1';
...
ALTER TABLE `dorkblog`.`gl_users`
ADD COLUMN `stretch` int(8) unsigned NOT NULL default '1';
ADD COLUMN `salt`varchar(64) NOT NULL default '',
ADD COLUMN `algorithm` tinyint(3) NOT NULL default '0',[/code]

and then save the db to a newly exported file.sql and then I choose "Migrate" and select the file.

I see the screen that says it was successful, but not the screens following that, usually telling me what the db has but the director(y|ies) doesn't|don't.

The last hurdle is this message:[code]
256 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE uid = 3' at line 1 @ /var/www/system/databases/mysqli.class.php line 279

Call Stack
#	Function	File	Line
1	trigger_error	/var/www/system/databases/mysqli.class.php	279
2	dbQuery	/var/www/system/lib-database.php	213
3	DB_query	/var/www/system/lib-security.php	1298
4	SEC_updateUserPassword	/var/www/system/lib-security.php	1244
5	SEC_encryptUserPassword	/var/www/system/lib-security.php	746
6	SEC_authenticate	/var/www/html/users.php	818
 array(3) {
  ["sql"]=>
  string(137) "UPDATE gl_users SET passwd = 'bb22cd7403595688fd81560a87b2f36a', salt = '8XhuZdIsRB8ge3IPY2ykKt', algorithm ='', stretch =  WHERE uid = 3"
  ["ignore_errors"]=>
  int(0)
  ["result"]=>
  bool(false)
}[/code]

Since it's barking about syntax, I have Server version: 5.1.71
Password resets bomb as well. :(
Thanks for the help so far![/p][/QUOTE]

Options:

HTML Mode:

Geeklog

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Stories last 2 weeks

Comments last 2 weeks

Trackbacks last 2 weeks

Pages last 2 weeks

Links last 2 weeks

Downloads last 2 weeks