Geeklog
The secure CMS.
Login
Contribute
Support
Polls
Links
Forum
Downloads
Directory
Login
Contribute
Support
Polls
Links
Forum
Downloads
Directory
Welcome to Geeklog Sunday, April 22 2018 @ 10:07 pm EDT
Forum Index
Popular Topics
Select a Forum
» General Geeklog Discussions
» You and your Sites
» Geeklog Related Sites
» Off-Topic
» Feedback
» General Geeklog Support
» Installation Support
» Plugin Support
» Theming Support
» Documentation, Tips & Tricks
» Plugins
» Themes
» PHP Blocks
» Cool Hacks
» Geeklog
» Plugins
» Themes
» Other Aspects
» GSOC
» Français
» Deutsch
» 日本人
Forum Index
Support
Installation Support
upgrade issues fom 1.8.2sr1 to 2.0.0
Post New Reply
Author:
Mood:
No Mood
angry
angelic
artistic
awake
blah
blank
brainy
caffeinated
cheerful
cold
confused
curious
determined
dirty
dizzy
embarrassed
envious
flirty
excited
freakingout
full
giggly
gloomy
groggy
grossedout
grumpy
happy
hopeful
hot
hungry2
hungry
hyper
indescribable
indifferent
lazy
loved
magical
mellow
moody
musical
naughty
nerdy
okay
rockin
sad
sick
silly
sleepy
smart
sneezy
sore
spooky
stressed
stupid
surprised
thirsty
thoughtful
tired
unfocused
working
worried
Code
Font Color
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font Size
Tiny
Small
Normal
Large
Huge
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:
Preview
Submit
Cancel
Search
Search
advanced search
Resources
About
What is Geeklog?
Core Developers
Getting started
Download Geeklog
Documentation
Wiki Docs
Demo Site (v2.1.3)
Support
FAQ
Forums
Mailing Lists
Report a Bug
Request a Feature
Geeklog Security
Development
Getting Started
Plugin Developers Guide
Download Source Code
Documented Source Code
Roadmap
Topics
Home
Development
(340)
Geeklog
(223)
Plugins
(123)
Themes
(6)
News
(378)
Announcements
(263)
Geeklog.net
(31)
Security
(77)
Spam
(11)
User Functions
Login
Username
Password
Login
Don't have an account yet? Sign up as a
New User
!
Lost your
password
?
What's New
Stories
last 2 weeks
No new stories
Comments
last 2 weeks
No new comments
Trackbacks
last 2 weeks
No new trackback comments
Pages
last 2 weeks
No new pages
Links
last 2 weeks
No recent new links
Downloads
last 2 weeks
No new files