Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 09:03 pm EST
Geeklog Forums
Upgrade probs
TimC
Anonymous
Decided to new thread this even tho i posted earlier...
Any help on this one? upgrading from 1.3.1 to 1.4. installed backed up db, all files copied up, selected upgrade and bang! MYsql error and the error log says
Upon further research I don't know about the other lines above but the registrationrequired is in the forum table if that helps...
Can anyone help? thanks..t
Any help on this one? upgrading from 1.3.1 to 1.4. installed backed up db, all files copied up, selected upgrade and bang! MYsql error and the error log says
Sun 10 Sep 2006 23:07:44 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:10:14 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:12:15 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:13:16 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:18:23 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:18:44 EDT - 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 '' at line 1. SQL in question: SELECT registrationrequired FROM
Sun 10 Sep 2006 23:10:14 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:12:15 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:13:16 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:18:23 EDT - 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 '' at line 1. SQL in question: SELECT * FROM
Sun 10 Sep 2006 23:18:44 EDT - 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 '' at line 1. SQL in question: SELECT registrationrequired FROM
Upon further research I don't know about the other lines above but the registrationrequired is in the forum table if that helps...
Can anyone help? thanks..t
4
5
Quote
Timc
Anonymous
i took out all the menu tables in the old db and registrationrequired is now nowhere in the backup yet now when i hit upgrade i get just this in the log..
so where is it gettting registration required from now?
Sun 10 Sep 2006 23:50:24 EDT - 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 '' at line 1. SQL in question: SELECT registrationrequired FROM
so where is it gettting registration required from now?
6
4
Quote
TimC
Anonymous
I cut and pasted the mysql from the backup file and performed it that way without the forum crap and bingo it went ok.... and site is up.....
I would appreciate a response tho on why the above prob occurred in the first place? thanks..t
I would appreciate a response tho on why the above prob occurred in the first place? thanks..t
6
7
Quote
TimC
Anonymous
I cut and pasted the mysql from the backup file and performed it that way without the forum crap and bingo it went ok.... and site is up.....
I would appreciate a response tho on why the above prob occurred in the first place? thanks..t
I would appreciate a response tho on why the above prob occurred in the first place? thanks..t
4
6
Quote
Timc
Anonymous
I take that back.....site came up but even clicking to go to front page for default login got the mysql errors...the other lines in the first post ..so what gives? thanks..t
4
5
Quote
13
Anonymous
Hey Dirk....it came from the forum plugin...older one that came out about the time as 1.3.10
i finally got the old version up and running again for now but will have to just start over when that 1.4 comes out next weekend anew and reinstall everything....
my big question is the lines above that that don't refer to a specific thing..what do those lines indicate? thanks..t
i finally got the old version up and running again for now but will have to just start over when that 1.4 comes out next weekend anew and reinstall everything....
my big question is the lines above that that don't refer to a specific thing..what do those lines indicate? thanks..t
4
6
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by 13: but will have to just start over when that 1.4 comes out next weekend anew and reinstall everything....
Nah. 1.4.1 will be out as a beta first, followed by 1 or 2 release candidates or so. So it will be at least another 4 weeks before the final version is out. And even then we'll support 1.4.0 with security releases until 1.4.2 is out.
Quote by 13: my big question is the lines above that that don't refer to a specific thing..what do those lines indicate? thanks..t
That usually means that they referred to a table whos name was missing from the $_TABLES array. Again, that's an indication of a partial install of some add-on or plugin.
bye, Dirk
5
5
Quote
13
Anonymous
ok will do clean install on 1.4 then..it has to be more stable than my crippled site now..haha..
and thanks for the info and the explanation...I am not proficient in any of this..just 6-7 yrs of jumping in blindly and learning by doing and trial and error..thanks for the help..t
and thanks for the info and the explanation...I am not proficient in any of this..just 6-7 yrs of jumping in blindly and learning by doing and trial and error..thanks for the help..t
5
6
Quote
All times are EST. The time is now 09:03 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content