Welcome to Geeklog, Anonymous Monday, December 30 2024 @ 12:49 pm EST

Geeklog Forums

upgrade from 1.3.11 to 1.4 not sucessful - An SQL error has occurred. Please see error.log for detai


Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
An SQL error has occurred. Please see error.log for details. i got this when i try to open my page

i backed up all the files and left all the files on the server

then i copied the new geeklog 1,4 files over the old one and after that i copied the old config and libcommon files of 1,3,11 geeklog over the new config and libcommon files of 1,4

i choose upgrade clicked next and got sucess message

Installation of Geeklog 1.3.11 complete!

Congratulations, you have successfully installed Geeklog. Please take a minute to read the information displayed below.

Then click here to go to your site's front page and learn about the default login.
Check Permissions

Geeklog requires certain files and directories to be writable. To check if those are set up properly, please use this script.
Security Warning

Once your site is up and running, don't forget to remove the install directory, /home/badbreat/public_html/admin/install, and change the password of the default 'Admin' account.

when i tried to open my home page i got this error

An SQL error has occurred. Please see error.log for details.

i also disabled all of the plugins in php my admin and that didnt helped

i opened the error log under root directory of my server logs and the error.log says following

Mon Feb 6 21:19:52 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:21:13 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:21:28 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:23:44 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:24:14 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:24:24 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:29 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:33 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:34 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:35 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:37 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:40 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:42 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:43 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:44 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:46 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:47 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:48 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:49 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:50 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:52 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:53 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:54 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:31:55 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:34:06 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all
Mon Feb 6 21:37:27 2006 - 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 '::all' at line 1. SQL in question: SELECT sid FROM gl2_stories WHERE draft_flag = 0 AND date 0 ORDER BY date DESC LIMIT ::all


sorry for long post but be specific because i am not expert in my admin adn programming

please help i do not want to go back to 1,3,11
 Quote

Status: offline

mevans

Forum User
Full Member
Registered: 02/08/04
Posts: 393
Location:Texas
Quote by garfy:
then i copied the new geeklog 1,4 files over the old one and after that i copied the old config and libcommon files of 1,3,11 geeklog over the new config and libcommon files of 1,4


Don't copy your old config.php and lib-common.php over the new ones for Geeklog 1.4.0. You need to 'migrate' your configuration settings to the new files. You need to start with the ones from 1.4.0, edit them to put your settings (database, paths, urls), then do the upgrade.

Good luck!
Mark
 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
i fixed it

the reason was copying old config and lib common over new one

i have a question

where is fck editor

i can not see it anywhere

when i try to post a story there is no fck editor
 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
Quote by mevans:
Quote by garfy:
then i copied the new geeklog 1,4 files over the old one and after that i copied the old config and libcommon files of 1,3,11 geeklog over the new config and libcommon files of 1,4


Don't copy your old config.php and lib-common.php over the new ones for Geeklog 1.4.0. You need to 'migrate' your configuration settings to the new files. You need to start with the ones from 1.4.0, edit them to put your settings (database, paths, urls), then do the upgrade.

Good luck!
Mark


the second i post the solution i find your answer on geeklog

thank you

but still i can not find fck editor anywhere

 Quote

Status: offline

mevans

Forum User
Full Member
Registered: 02/08/04
Posts: 393
Location:Texas
Look in your config.php and find:

$_CONF['advanced_editor'] = false;

Change that to true and then the editor will magically appear next time you enter/edit a story in html format.

Mark
 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
Quote by mevans: Look in your config.php and find:

$_CONF['advanced_editor'] = false;

Change that to true and then the editor will magically appear next time you enter/edit a story in html format.

Mark


thank you mark

i did that but there is a problem with my theme

i have an axons theme and fck editor works fine in professional theme but not in axons theme

there are no icons for aligning the text and bold text etc...
also i can not post the story because it tells me this
Please fill in the Title and Intro Text fields


and i filled all the fields

does anybody knows what exactly should i copy to my theme files

 Quote

Status: offline

mevans

Forum User
Full Member
Registered: 02/08/04
Posts: 393
Location:Texas
Look in the header.thtml file for the professional theme, you will see:

Text Formatted Code
{feed_url}
{plg_headercode}
{advanced_editor}

 


Right after the stylesheet line. Copy these to your header.thtml for your theme and that should get your started. Depending on how old your theme is, you may need to copy over the navbar/ directory and also the storyeditor_advanced.thtml from the admin/story/ directories from the professional theme.

I just completed upgrading avp_aeon theme, basically, I just let Geeklog tell me what it couldn't find and started copying those files over from the professional directory.

Don't forget you will also need to grab some of the new CSS out of the style.css, all the navbar stuff needs to go over, as well as, the new plugin css codes.

It takes a bit of time and effort to upgrade a theme for 1.4.0, but it is worth the work.

Good Luck!
Mark
 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
Quote by mevans: Look in the header.thtml file for the professional theme, you will see:

Text Formatted Code
{feed_url}
{plg_headercode}
{advanced_editor}


 


Right after the stylesheet line. Copy these to your header.thtml for your theme and that should get your started. Depending on how old your theme is, you may need to copy over the navbar/ directory and also the storyeditor_advanced.thtml from the admin/story/ directories from the professional theme.

I just completed upgrading avp_aeon theme, basically, I just let Geeklog tell me what it couldn't find and started copying those files over from the professional directory.

Don't forget you will also need to grab some of the new CSS out of the style.css, all the navbar stuff needs to go over, as well as, the new plugin css codes.

It takes a bit of time and effort to upgrade a theme for 1.4.0, but it is worth the work.

Good Luck!
Mark


ok mark thx it works i can post the story but still i can not see the icons for aligning the text and make it bold etc

i copied all the folders from professional theme that were not in my folder

i really do not know what to do , geeklog doeasnt say anything about not finding any files

 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
Quote by mevans: Look in the header.thtml file for the professional theme, you will see:

Text Formatted Code
{feed_url}
{plg_headercode}
{advanced_editor}


 


Right after the stylesheet line. Copy these to your header.thtml for your theme and that should get your started. Depending on how old your theme is, you may need to copy over the navbar/ directory and also the storyeditor_advanced.thtml from the admin/story/ directories from the professional theme.

I just completed upgrading avp_aeon theme, basically, I just let Geeklog tell me what it couldn't find and started copying those files over from the professional directory.

Don't forget you will also need to grab some of the new CSS out of the style.css, all the navbar stuff needs to go over, as well as, the new plugin css codes.

It takes a bit of time and effort to upgrade a theme for 1.4.0, but it is worth the work.

Good Luck!
Mark


Mark thx i fixed everything

i copied the nav section of css to my theme css

thx Chest-Slam Celebration
 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
the only thing that is wrong that there is no alignment to both sides only to left right or center

why is that

i always use only align justify to both sides Banging your head
 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
Quote by garfy:
Quote by mevans: Look in the header.thtml file for the professional theme, you will see:

Text Formatted Code
{feed_url}
{plg_headercode}
{advanced_editor}



 


Right after the stylesheet line. Copy these to your header.thtml for your theme and that should get your started. Depending on how old your theme is, you may need to copy over the navbar/ directory and also the storyeditor_advanced.thtml from the admin/story/ directories from the professional theme.

I just completed upgrading avp_aeon theme, basically, I just let Geeklog tell me what it couldn't find and started copying those files over from the professional directory.

Don't forget you will also need to grab some of the new CSS out of the style.css, all the navbar stuff needs to go over, as well as, the new plugin css codes.

It takes a bit of time and effort to upgrade a theme for 1.4.0, but it is worth the work.

Good Luck!
Mark


Mark thx i fixed everything

i copied the nav section of css to my theme css

thx Chest-Slam Celebration


i still have a problem

if i include these 3 lines into header.htm of my axons theme everything is ok and i can post the articles but my header and footer get a padding or border that is white and my banner looks like it floats in the middle of the page

i do not know how to fix that, i want that my banner and footer do not have any padding or border and that they have 100% width, now it looks like they have 96 % width and the rest of it is the white space

can somebody fix that

i doubt axons will fix that because his site is down
 Quote

All times are EST. The time is now 12:49 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