Adrian@TORQEN Posted February 6, 2013 Posted February 6, 2013 Guys, Can you please run a quick SQL query to replace all URLs like this: http://www.350z-uk.com/newforum/public/style_emoticons/default/ with http://www.350z-uk.com/public/style_emoticons/default/ ? It's a shame that the new forum is full of missing imgs like here: It shouldn't take more than 5 minutes Thanks! Quote
Adrian@TORQEN Posted February 6, 2013 Author Posted February 6, 2013 (edited) http://www.mydigitallife.info/how-to-find-and-replace-text-in-mysql-database-using-sql/ Alternatively, turn off forum, dump the DB in a SQL file, open it with some text editor, find & replace string, save, import new DB, turn forum on All done, but more time and operations involved Edited February 6, 2013 by octet Quote
Ricey Posted February 6, 2013 Posted February 6, 2013 *waits for Adrian to be told to pipe down* Quote
Keyser Posted February 6, 2013 Posted February 6, 2013 *waits for Adrian to be told to pipe down* Quote
Vik54 Posted February 6, 2013 Posted February 6, 2013 He has a point it is feckin annoying... but then I have no idea of the work involved in rectifying it Quote
Adrian@TORQEN Posted February 6, 2013 Author Posted February 6, 2013 He has a point it is feckin annoying... but then I have no idea of the work involved in rectifying it I DO Quote
Adrian@TORQEN Posted February 6, 2013 Author Posted February 6, 2013 *waits for Adrian to be told to pipe down* Yeah, I know the feeling, it's most likely going to happen Quote
Lexx Posted February 6, 2013 Posted February 6, 2013 Admin have been a little busy with personal lives of late. It is on the list of things to do I believe. I'm sure bugging them about it in public will bump it up their priority list though Quote
Adrian@TORQEN Posted February 6, 2013 Author Posted February 6, 2013 They can always delegate stuff to other mods / people willing to help Quote
Lexx Posted February 6, 2013 Posted February 6, 2013 They can always delegate stuff to other mods / people willing to help They do Quote
Ricey Posted February 6, 2013 Posted February 6, 2013 *waits for Adrian to offer his services and be told to pipe down* Quote
Adrian@TORQEN Posted February 6, 2013 Author Posted February 6, 2013 Neah, not anymore, learned my lesson two years ago. No point. Quote
Ricey Posted February 6, 2013 Posted February 6, 2013 Neah, not anymore, learned my lesson two years ago. No point. Aye but in fairness I suppose you were new 2 years ago so inviting you to fiddle with the forum may have been a little naive. Now we know your a total zed nerd you should have full tinkering access if the offers there ;-) Quote
Chesterfield Posted February 6, 2013 Posted February 6, 2013 I'll see what I can do. I'm sure there's a guide on template monster or something. Quote
Adrian@TORQEN Posted February 6, 2013 Author Posted February 6, 2013 I'll see what I can do. I'm sure there's a guide on template monster or something. I sense a bit of sarcasm there Quote
spursmaddave Posted February 6, 2013 Posted February 6, 2013 I agree that it seems a very simple thing to sort out with a bit of SQL know how Quote
stuarty Posted February 7, 2013 Posted February 7, 2013 How come when the new version of the forum opened I could post pictures and now I can't as it says the image are to large and it's the same images? Quote
Ekona Posted February 7, 2013 Posted February 7, 2013 Because they're too expensive for a day, should only be £150 max. ;) I have no idea, seems odd. You're sure they were okay on the new forum originally? Quote
Chris`I Posted February 7, 2013 Posted February 7, 2013 How come when the new version of the forum opened I could post pictures and now I can't as it says the image are to large and it's the same images? Can you do a screen grab and post it here or PM me/Chesterfield please? As for the smilies issue, I'll make sure its bumped up the list and chat to Chesterfield about how we can sort it. Quote
stuarty Posted February 7, 2013 Posted February 7, 2013 Because they're too expensive for a day, should only be £150 max. ;) I have no idea, seems odd. You're sure they were okay on the new forum originally? I posted a photo of my new car when the forum first went online. Now when i try to upload photo's including the original photo, its says image is too large. Quote
Ekona Posted February 7, 2013 Posted February 7, 2013 What size is the image, both in terms of data and pixels? Quote
Ebized Posted February 7, 2013 Posted February 7, 2013 Because they're too expensive for a day, should only be £150 max. ;) I have no idea, seems odd. You're sure they were okay on the new forum originally? I posted a photo of my new car when the forum first went online. Now when i try to upload photo's including the original photo, its says image is too large. Excuse me for asking, but are you trying to that by the "Choose files......" option? - if so then it will bulk (see the limits noted). Best to use a picture hosting site (if you do not already have one) and paste the URL's in the pop-up window when you click on the little green box on the toolbar. Never had a problem myself with images of varying sizes using that method. Quote
Chris`I Posted February 7, 2013 Posted February 7, 2013 Guys, Can you please run a quick SQL query to replace all URLs like this: http://www.350z-uk.com/newforum/public/style_emoticons/default/ with http://www.350z-uk.com/public/style_emoticons/default/ ? Think Chesterfield has done a quick fix, see if its worked or let us know the thread if it hasn't. I cant do it from work, for some reason they don't like us SSHing out of the corporate firewall for some reason Quote
glrnet Posted February 7, 2013 Posted February 7, 2013 No problem Adrian I like to help out where I can Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.