| Author |
Topic |
|
JoePec
Starting Member
14 Posts |
 Posted - 2004-12-24 : 18:54:36
|
| Newbie here. My message board got hammered due to the latest worm affecting phpbb boards. PHP has released an update but there are issues with MS SQL and Sessions. Probably a dumb question, but I will ask. Is it possible to transfer MS SQL tables to MySQL tables?Thanks.John |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-24 : 21:58:23
|
| Yes. :) Why in the world would you want to do that though? You can use DTS, bcp, linked servers, etc. Do you have Books Online?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-25 : 07:08:40
|
| Thanks for responding. I don't know what you mean. My situation is now this, I am told:My board needed updated because of the worm that was attacking phpbb message boards. I did that. But now the latest PHP is version 4.3.10. It has this issue with MS SQL and my phpbb_sessions table. From what I understand, there is a CVS(whatever that is) version that fixes this. But the phpbb.com forums state that most hosts will not upgrade until 4.3.11 is finalized.I don't know how long of a wait that could be. I am unfortunately not in a position to wait.Now the way I figure it, I can do a couple of things.I believe my plan with my host allows for both an MySQL db and a MS SQL one. If so, couldn't I use the MySQL db, as it seems to be working fine with the upgrades? Now if I can save my old board's posts, that is the ultimate. But I was assuming that I needed to transfer from MS SQL to MySQL. Your post leads me to believe I don't have to do that?? If necessary, I will just move to MySQL with a new board. My lord, what a mess. But hey, that's life at times. These past 3 days are some of the worst of my life, I know that. I would rather be back in Vietnam in 1969 than doing this. Or Parris Island. Or still married to my first wife. I can go on.Thanks. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-25 : 08:39:19
|
| Odd - they don't mention this on the latest news pageI guess you are talking abouthttp://www.phpbb.com/phpBB/viewtopic.php?t=249121CVS = Concurrent Versioning SystemLets see - this is a bb which has a security hole and the fix causes it to fail against sql server - and they aren't rushing out a release to cope with it. Don't know what the worm does but sounds like they are sayng sql server sites usingthe product should be closed down for the time beingLooking at that site I think you should consider the product itself.Maybe convert to Snitz?This posthttp://www.phpbb.com/phpBB/viewtopic.php?t=250114sounds like they don't test very thouroughly on sql server before release so maybe that isn't a good backend for PHP.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-25 : 13:22:36
|
| Can you tell us exactly what error you're getting? It's possible we can help you with a fix in the interim. I've personally never liked that forum software. It might be a good opportunity to upgrade to the snitz software.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-25 : 15:44:39
|
| Okay. Thanks for the help.Here is what I have done. My plan with my host allows me 2 databases. I had been using the ms sql for the board. Since the problem with PHP right now is with ms sql, I figured I would transfer my board to a mysql. I had my host create the mysql.Now I found a popular program that does the conversion. It allows a trial run. Where it only transfers the top 5 rows of a table. I did that.For the first time in 3 days I can access the message board. But there are some hangups. Now for example there are just 5 forums but that is due to only 5 rows of the forums table getting transferred. But when I try to access a topic, I get the following error message :Could not obtain topic information DEBUG MODE SQL Error : 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 '' at line 11 SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.forum_id = 21 AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND t.topic_type <> 2 ORDER BY t.topic_type DESC, t.topic_last_post_id DESC LIMIT 0, Line : 327 File : /home/jdi/public_html/forum/viewforum.php Now if this thing is at a stage where I may be eons getting my board up, I may as well install a new one and kiss the 23,000 posts good bye. I lost about 65,000 a year ago. I am at a point where my traffic has to be salvaged. Any ideas, thanks. And what is so much better with the Snitz board? Can it be subject to worm attacks like the phpbb was? I am interested. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-25 : 16:21:35
|
| By the way, I have been to the Snitz site. There doesn't seem to be a whole lot of activity. Not many posts. I am fond of the "who's online" function and can't find anything there about one. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-12-26 : 05:48:34
|
| Mp 2p worth is that think you could be much better off solving the poblems you have with your MS SQL database, rather than either a) trying to migrate to MySQL [and probably discovering a whole new raft of problems] or b) moving to a new board [and losing all your messages and registered users]The link Nigel posted suggests your old version will run just fine if you use the right file permissions.Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-26 : 11:20:41
|
| Drop the LIMIT 0 off the end of that statement and try it again Joe.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-12-26 : 12:05:54
|
quote:
Originally posted by JoePec
By the way, I have been to the Snitz site. There doesn't seem to be a whole lot of activity. Not many posts. I am fond of the "who's online" function and can't find anything there about one.
Snitz has been releasing pretty stable code for a while now so there isn't much activity on the board in terms of bug fixes, etc. Their development right now is focused on creating an international version and much of that goes on in some private forums. There are a number of MODs available. I'm guessing there would be one available that would show who's online. I'd search here (http://forum.snitz.com/forum/forum.asp?FORUM_ID=25) for it.The people on the board are great for technical support. They may even have a conversion script you could use.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-26 : 17:38:58
|
| Thanks for all the help. Kristen, I must be missing something as I didn't see anything in a preceding post about file permissions??I tried to migrate the tables. For some reason, it would not work. I used a transfer utility that actually let me copy the first 5 rows of every table. But something just wouldn't work out and I couldn't find the answer.So I started a new board with my MySQL db that also comes with my host's plan. I figure I'm shot now for transferring(I haven't deleted the tables in my MS SQL db yet), but at least I am back online. Too much longer and I would be a cooked goose. I will consider the Snitz board. In fact, I'll be honest. I would have probably tried it now except I am familiar with how to set the ads up with the phpbb. And I couldn't afford any more lost time. Maybe down the road I will switch when it wouldn't be an emergency. That is if they have converters.Thanks again for all your help.Joe |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-26 : 22:45:43
|
| I've just set up a snitz forum here http://www.mindsdoor.comA step by step guide (including getting a host...) http://www.mindsdoor.net/createForum.htmlAmazing how simple it was. There are also very few tables involved so you shouldn't have many problems inserting your traffic into the database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-26 : 23:00:29
|
| nr-I am getting error pages for both of those links. Thanks. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-26 : 23:11:23
|
| Because I put a full stop at the end of both - try now.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-12-27 : 02:22:40
|
| "I must be missing something as I didn't see anything in a preceding post about file permissions??"Well, I can't find it now either, sorry. I did some googling around the problem too, so it may be that it was in that,r ather than the links above. Basically, as I remember it [and I know nothing about Unix] it said that if the Public file permissions were set a particular way the worm would not be able to modify the files.Mind you, if it was that easy I suppose all the people in the phpbb forum would have considered it?Kristen |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-27 : 22:49:04
|
| Several days ago, I tried to register to the Snitz forums. I never did receive an activation email. So this morning(about 14 hours ago), I went to their contact area. I filled out the information stating that I was interested in their message board. That I wanted to register to their forums and ask some questions. I also explained that I had gone through the registration and hadn't received the activation email. I still have not heard from them. Seems a bit odd to me. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-28 : 00:00:19
|
| Try asking the questions here under site related or yak coral.Have you download it and tried running it? You might be able to answer your own questions by looking at the code.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-28 : 15:10:05
|
| Two things bother me. First off, the activation email may not have worked. Very important to let new people join to post. Secondly, they didn't respond to my contact inquiry. Which does not bode well. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-28 : 15:17:17
|
| Think the idea is that it's very simmple and easy to change the code yourself. Together with a lot of sites running the software and willing to help newcommers means that they don't need to spend much effort on support.I've registered - will see how long it takes.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
JoePec
Starting Member
14 Posts |
Posted - 2004-12-28 : 17:02:25
|
| Let me know, nr. Thank you sir. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-28 : 17:14:30
|
| Just received the registration email.Suspect there is something wrong with your email.I used a hotmail address==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Next Page
|
Convert SQL tables to MySQL ??