XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / small migration issue with xoops_tplsource
Register
1
mattm
small migration issue with xoops_tplsource

  • 2005/2/5 13:31

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


Has anyone had a problem, during migration, with uploading the contents of "xoops_tplsource"?

I'm finding that I'm getting syntax errors when I try to upload using phpmyadmin. It comes up with

Quote:

#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 'visit.php?cid=<{$link.cid}>&' at line 1


Immediately prior to the 'visit.php...' part, is a phpsession ID in " quotes (not sure if that is any use to know but thought I'd mention it).

Can anyone help?
2
m0nty
Re: small migration issue with xoops_tplsource

  • 2005/2/5 13:38

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


i think it's to do with the method u exported the db..

if you used quotes for fieldnames and the text contains quotes aswell MySQL might think that you're closing a table/field name and starting another..

so in your case > 'visit.php?cid=<{$link.cid}>&' maybe confusing it..

it's hard to say without seeing some of the query.. some manual editing of the .sql or csv file might be needed
3
mattm
Re: small migration issue with xoops_tplsource

  • 2005/2/5 13:47

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


Thanks for the response. I'm using phpMyAdmin with the options set to

add drop table - selected
enclose table & field names with backquotes - selected

complete inserts - selected

here is the sql output with session ID edited - (don't know if that is necessary or not but seemed sensible!)
Quote:

ERROR: Unknown Punctuation String @ 363
STR: =<
SQL: INSERT INTO xoops_tplsource VALUES (36, '\n \n \n \n \n
<{$lang_category}> <{$link.category}>
&lid=<{$link.id}>\'


It goes on from there but that covers the area it appears to be upset about. Don't really know enough to be able to troubleshoot the syntax.
4
mattm
Re: small migration issue with xoops_tplsource

  • 2005/2/5 14:02

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


OK - just re-read your post. Unselecting "Enclose table and field names with backquotes" has fixed the problem.

Thanks!
5
highlander
Re: small migration issue with xoops_tplsource

  • 2005/2/5 14:04

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Try changing :
<a href="?PHPSESSID=*snip!*"'visit.php?cid=<{$link.cid}>&lid=<{$link.id}>'


to :
<a href="?PHPSESSID=*snip!*"'visit.php?cid=<{$link.cid}>&lid=<{$link.id}>'


Highlander

edit :- too late !
6
mattm
Re: small migration issue with xoops_tplsource

  • 2005/2/5 14:09

  • mattm

  • Just popping in

  • Posts: 28

  • Since: 2004/3/8 2


@highlander

Thanks for looking - looks like it just required a little tinkering with phpmyadmin.

At least the question is now answered for anyone else that has the problem!

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

250 user(s) are online (197 user(s) are browsing Support Forums)

Members: 0

Guests: 250

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits