Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #11  
Old 03-05-2003, 10:28 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well, you can run the nessesary queries within phpmyadmin, without hacking of course
Reply With Quote
  #12  
Old 03-05-2003, 11:25 AM
stark427's Avatar
stark427 stark427 is offline
 
Join Date: Aug 2002
Posts: 147
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 :

Code:
http://www.synthpopavenue.gr/forumdisplay.php?forumid=8
and here is the one from the new :

Code:
http://www.synthpopavenue.gr/forum/forumdisplay.php?forumid=8
the steps of what I should do would be much appreciated.
Reply With Quote
  #13  
Old 03-05-2003, 11:40 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

normally this would work:

[sql]UPDATE post SET pagetext=REPLACE(pagetext,'http://www.synthpopavenue.gr/','http://www.synthpopavenue.gr/forum/')[/sql]
Reply With Quote
  #14  
Old 03-05-2003, 12:47 PM
stark427's Avatar
stark427 stark427 is offline
 
Join Date: Aug 2002
Posts: 147
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I get this error :

Code:
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
Reply With Quote
  #15  
Old 03-05-2003, 01:02 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nice...., tell your mysql to describe the error a bit more, because i don't see an error in this query.
Reply With Quote
  #16  
Old 03-05-2003, 01:13 PM
stark427's Avatar
stark427 stark427 is offline
 
Join Date: Aug 2002
Posts: 147
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

May If I try putting the query in text file and run it from there ?
Reply With Quote
  #17  
Old 03-05-2003, 01:15 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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???
Reply With Quote
  #18  
Old 03-05-2003, 01:16 PM
stark427's Avatar
stark427 stark427 is offline
 
Join Date: Aug 2002
Posts: 147
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes!
It worked with the TXT file

thanx Xenon
Reply With Quote
  #19  
Old 03-05-2003, 01:17 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

really?

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

you're welcome
Reply With Quote
  #20  
Old 03-05-2003, 01:19 PM
stark427's Avatar
stark427 stark427 is offline
 
Join Date: Aug 2002
Posts: 147
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's version 2.2.0

and MySQL v3.23.55 ( I think)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:44 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04219 seconds
  • Memory Usage 2,248KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete