Welcome to Geeklog, Anonymous Friday, October 11 2024 @ 11:27 pm EDT
Geeklog Forums
Upgrade problem
Status: offline
ShdwRulr
Forum User
Regular Poster
Registered: 09/13/03
Posts: 78
When I go to the 3rd page for geeklog's installation, I get this
Warning: inst_dodatabaseupgrades(/home/shadowru/public_html/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php): failed to open stream: No such file or directory in /home/shadowru/public_html/geeklog/public_html/admin/install/install.php on line 491
What is wrong?
Bla bla bla
Warning: inst_dodatabaseupgrades(/home/shadowru/public_html/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php): failed to open stream: No such file or directory in /home/shadowru/public_html/geeklog/public_html/admin/install/install.php on line 491
What is wrong?
Bla bla bla
3
2
Quote
FreakWorld
Anonymous
I think you have your URL's set wrong in the cofig.
That is unless you do have copy URL's.
/public_html/geeklog/public_html/
That is unless you do have copy URL's.
/public_html/geeklog/public_html/
5
4
Quote
Status: offline
ShdwRulr
Forum User
Regular Poster
Registered: 09/13/03
Posts: 78
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 '( fid int unsigned NOT NULL auto_increment, type varchar(30
Now I get the above problem.
Bla bla bla
Now I get the above problem.
Bla bla bla
6
8
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The error seems to be coming from the first line in the update file (that you seemed to be missing in your earlier post). There's nothing wrong with the syntax in that file, though.
I'd suggest double-checking that you did indeed upload / replace all the new files, restoring the database from your backup and trying again ...
bye, Dirk
I'd suggest double-checking that you did indeed upload / replace all the new files, restoring the database from your backup and trying again ...
bye, Dirk
10
8
Quote
Status: offline
ShdwRulr
Forum User
Regular Poster
Registered: 09/13/03
Posts: 78
I am running 1.3.8-1sr3 and I am getting dummy error when I go back to my original files.
*** dummy entry ***
Tue Feb 24 21:04:58 2004 - 1054: Unknown column 'sp_inblock' in 'field list'. SQL in question: SELECT sp_id,sp_content,sp_title,sp_format,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) ORDER BY sp_id
Tue Feb 24 21:05:35 2004 - 1054: Unknown column 'sp_inblock' in 'field list'. SQL in question: SELECT sp_id,sp_content,sp_title,sp_format,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) ORDER BY sp_id
Tue Feb 24 21:05:39 2004 - 1054: Unknown column 'sp_inblock' in 'field list'. SQL in question: SELECT sp_id,sp_content,sp_title,sp_format,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) ORDER BY sp_id
Anyways, I went to upgrade and it still got the same error as from my previous post. Finally, I restored my newer files and I get the same error.
Bla bla bla
*** dummy entry ***
Tue Feb 24 21:04:58 2004 - 1054: Unknown column 'sp_inblock' in 'field list'. SQL in question: SELECT sp_id,sp_content,sp_title,sp_format,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) ORDER BY sp_id
Tue Feb 24 21:05:35 2004 - 1054: Unknown column 'sp_inblock' in 'field list'. SQL in question: SELECT sp_id,sp_content,sp_title,sp_format,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) ORDER BY sp_id
Tue Feb 24 21:05:39 2004 - 1054: Unknown column 'sp_inblock' in 'field list'. SQL in question: SELECT sp_id,sp_content,sp_title,sp_format,sp_php,sp_inblock FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) ORDER BY sp_id
Anyways, I went to upgrade and it still got the same error as from my previous post. Finally, I restored my newer files and I get the same error.
Bla bla bla
4
5
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by ShdwRulr: Tue Feb 24 21:05:39 2004 - 1054: Unknown column 'sp_inblock' in 'field list'.
When are you getting this error (your post isn't clear on this)? "sp_inblock" is a new field in the Static Pages plugin 1.4 that's included with 1.3.9rc1.
To me, this still looks like you're mixing files (and the database) from old and new versions ...
bye, Dirk
8
3
Quote
All times are EDT. The time is now 11:27 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