Moving the forums to another directory + redirecting in index.php ??

[Xenon]

well, you can run the nessesary queries within phpmyadmin, without hacking of course

[stark427]

Originally posted by Xenon
well, you can run the nessesary queries within phpmyadmin, without hacking of course

Erm thanx - but could you please elaborate more on this? - only if you have the time.
I have used phpmyadmin only 2-3 times for really simple things, but running queries.... no

If that is of any help :

here is the thread URL of the old forum :

http://www.synthpopavenue.gr/forumdisplay.php?forumid=8

and here is the one from the new :

http://www.synthpopavenue.gr/forum/forumdisplay.php?forumid=8

the steps of what I should do would be much appreciated.

[Xenon]

normally this would work:

[sql]UPDATE post SET pagetext=REPLACE(pagetext,'http://www.synthpopavenue.gr/','http://www.synthpopavenue.gr/forum/')[/sql]

[stark427]

I get this error :

SQL-query :  [Edit] 

UPDATE post SET pagetext=REPLACE(pagetext,\'http://www.synthpopavenue.gr/\',\'http://www.synthpopavenue.gr/forum/\')

MySQL said: 


You have an error in your SQL syntax near '\'http://www.synthpopavenue.gr/\',\'http://www.synthpopavenue.gr/forum/\')' at line 1

[Xenon]

nice...., tell your mysql to describe the error a bit more, because i don't see an error in this query.

[stark427]

May If I try putting the query in text file and run it from there ?

[Xenon]

hmm, i don't think it would change anything...

can maybe someone other answer that one, i really don't see why this query should have an error???

[stark427]

Yes!
It worked with the TXT file

thanx Xenon

[Xenon]

really?

weird... what version of phpmyadmin did you use?

you're welcome

[stark427]

It's version 2.2.0

and MySQL v3.23.55 ( I think)