Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Need help with SQL Syntax error after update

Asked Modified Viewed 4,164 times
K
kd6oji
K
kd6oji 10
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
asked
Junior Member

I've upgraded from 7.00.3 to 7.02.06. Now I am receiving the following error:

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 5You 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 5

My URL is http://www.collinares.net/index.php

Any help would be VERY appreciated.

server info follows:
Platform Type:
Debian
MySQL Version:
5.0.91-log
Perl Version:
5.8.8
PHP Version:
5.3.13
0 replies

6 posts

C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

The page is not redirecting properly mate.

Anyway the error will just be minor it should be gone now if you look at your news.php and delete the error in the log.
0 replies
J
JoiNNN
J
JoiNNN 10
  • Veteran Member, joined since
  • Contributed 850 posts on the community forums.
  • Started 100 threads in the forums
answered
Veteran Member

You upgraded from 7.00.3 straight to 7.02.06 :|? Looks like it... many file are missing and on top of that you set index.php as starting page, that`s why the page isn't redirecting properly.
0 replies
K
kd6oji
K
kd6oji 10
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

I was afraid of that. I will research the upgrade path.. arghhh.
Any pointers?
0 replies
C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

Restore your backup back to your version then upgrade 1 by 1



Read the read me also. ;)
0 replies
K
kd6oji
K
kd6oji 10
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

Got the many bits downloaded now, wow, bunch of files!
WOrking on restoring the backups as we speak, yes I did make them! B)

Thanks for the help, if I need anything else I will let you guys know.

Merged on Apr 14 2013 at 03:29:18:
Ok, I have succeeded in updating all of the packages and am now at v7.02.06.
Everything seems in order, yet I have one error:
Table 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't existTable 'collin_ar.fusion_errors' doesn't exist

across the top of my pages. This presented itself while moving from 7.01.06 to 7.02.00

Other than that it appears correct.

http://www.collinares.net

Thanks again everyone for the help up to now, almost got this bagged!

Merged on Apr 14 2013 at 06:48:47:
I was able to fix the problem using the instruction here:

http://www.php-fusion.co.uk/forum/viewthread.php?thread_id=28714#post_157773

Issue is now closed, hope it helps others down the line!
Edited by kd6oji on 14-04-2013 07:48,
0 replies
K
kd6oji
K
kd6oji 10
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

yes, it was successful. The one step I had missed prior was the .00 majors.
I might write a wiki post on it if I knew where it needed to go.
but again without the pointers I would have been lost still, so much thanks again.
0 replies

Category Forum

Upgrading issues - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 6 posts
  • Votes 0 votes
  • Topic users 3 members

3 participants

C
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
K
K
kd6oji 10
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
J
J
JoiNNN 10
  • Veteran Member, joined since
  • Contributed 850 posts on the community forums.
  • Started 100 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet