Adrian@TORQEN Posted February 6, 2013 Share 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 Link to comment Share on other sites More sharing options...
Adrian@TORQEN Posted February 6, 2013 Author Share 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 Link to comment Share on other sites More sharing options...
Ricey Posted February 6, 2013 Share Posted February 6, 2013 *waits for Adrian to be told to pipe down* Quote Link to comment Share on other sites More sharing options...
Keyser Posted February 6, 2013 Share Posted February 6, 2013 *waits for Adrian to be told to pipe down* Quote Link to comment Share on other sites More sharing options...
Vik54 Posted February 6, 2013 Share 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 Link to comment Share on other sites More sharing options...
Adrian@TORQEN Posted February 6, 2013 Author Share 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 Link to comment Share on other sites More sharing options...
Adrian@TORQEN Posted February 6, 2013 Author Share 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 Link to comment Share on other sites More sharing options...
Lexx Posted February 6, 2013 Share 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 Link to comment Share on other sites More sharing options...
Adrian@TORQEN Posted February 6, 2013 Author Share Posted February 6, 2013 They can always delegate stuff to other mods / people willing to help Quote Link to comment Share on other sites More sharing options...
Lexx Posted February 6, 2013 Share Posted February 6, 2013 They can always delegate stuff to other mods / people willing to help They do Quote Link to comment Share on other sites More sharing options...
Ricey Posted February 6, 2013 Share Posted February 6, 2013 *waits for Adrian to offer his services and be told to pipe down* Quote Link to comment Share on other sites More sharing options...
Adrian@TORQEN Posted February 6, 2013 Author Share Posted February 6, 2013 Neah, not anymore, learned my lesson two years ago. No point. Quote Link to comment Share on other sites More sharing options...
Ricey Posted February 6, 2013 Share 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 Link to comment Share on other sites More sharing options...
Chesterfield Posted February 6, 2013 Share Posted February 6, 2013 I'll see what I can do. I'm sure there's a guide on template monster or something. Quote Link to comment Share on other sites More sharing options...
Adrian@TORQEN Posted February 6, 2013 Author Share 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 Link to comment Share on other sites More sharing options...
spursmaddave Posted February 6, 2013 Share Posted February 6, 2013 I agree that it seems a very simple thing to sort out with a bit of SQL know how Quote Link to comment Share on other sites More sharing options...
stuarty Posted February 7, 2013 Share 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 Link to comment Share on other sites More sharing options...
Ekona Posted February 7, 2013 Share 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 Link to comment Share on other sites More sharing options...
Chris`I Posted February 7, 2013 Share 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 Link to comment Share on other sites More sharing options...
stuarty Posted February 7, 2013 Share 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 Link to comment Share on other sites More sharing options...
Ekona Posted February 7, 2013 Share Posted February 7, 2013 What size is the image, both in terms of data and pixels? Quote Link to comment Share on other sites More sharing options...
Ebized Posted February 7, 2013 Share 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 Link to comment Share on other sites More sharing options...
Chris`I Posted February 7, 2013 Share 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 Link to comment Share on other sites More sharing options...
Adrian@TORQEN Posted February 7, 2013 Author Share Posted February 7, 2013 Perfect, thanks! Quote Link to comment Share on other sites More sharing options...
glrnet Posted February 7, 2013 Share Posted February 7, 2013 No problem Adrian I like to help out where I can Quote Link to comment Share on other sites More sharing options...
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.