| Author |
 Topic  |
|
FourARSEDSheep
Starting Member
37 Posts |
 Posted - 14 February 2004 : 13:39:23
|
okay i officially hate mysql.
while i was testing my new mysql forum i put it in a test folder, when it was working properly i changed it back to the other folder. this is when things started going wrong.
the main page loaded fine, with all the forums and stuff.. but i couldnt get in to the forums.. it was still trying to use the access database?
so i changed the folders back again and they worked fine again..
then i delete the "forums" folder on the root of my server.. but i could still access it?!
so i deleted everything. then i reuploaded snitz, resent all the data from the access database to the mysql database.
when i loaded it up everything looked fine.. except none of the settings were carried across.. colour schemes.. images.. etc..
it just looked like a default snitz forum with my original data on it..
then i made a post, which worked fine.. then i went back to the forum - where it says how many times the thread has been read it was blank? and every previous post on the forum said "Edited by - on" at the bottom
ive gone back to access. any help would be greatly appreciated because we are running out of space on our server and access takes up far too much space!< |
 |
|
|
dibley
New Member
United Kingdom
91 Posts |
Posted - 17 April 2004 : 12:05:30
|
quote:
Originally posted by FourARSEDSheep
ive gone back to access. any help would be greatly appreciated because we are running out of space on our server and access takes up far too much space!
So does an access db require more space than a mySQL db, for the same number of posts / members?< |
.:dib:.
www.nightsouls.co.uk - Uk clubber & music forum.
www.animatronica.co.uk - Creators of themepark animatronics. |
|
|
|
AceC
New Member
Cyprus
68 Posts |
Posted - 21 April 2004 : 09:51:17
|
Got the following error having followed the steps at the start of this topic:
quote:
Error
SQL-query :
LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\TEMP\\php465.tmp' INTO TABLE `forum_badwords` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
MySQL said:
The used command is not allowed with this MySQL version
I am using phpMyAdmin 2.5.0 and mySQL 4.0.16-nt
< |
And the hit's just keep on comin' |
Edited by - AceC on 21 April 2004 09:52:32 |
|
|
|
Lazlow
Starting Member
3 Posts |
Posted - 22 May 2004 : 08:12:03
|
| Is it at all possible to use the converted database with other forums? Ie. Invision or phpBB? Or does this require another method? Thanks< |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
ndguy
Starting Member
13 Posts |
Posted - 01 July 2004 : 00:22:28
|
Chumawumba, Wannab, et..
I've gone to all the links you've posted for myfrontsql 2.5 and none is working. Could you post a link or email me a copy?
I appreciate your help. Jaber
< |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
ndguy
Starting Member
13 Posts |
|
|
ndguy
Starting Member
13 Posts |
Posted - 01 July 2004 : 12:50:31
|
Davio,
I just downloaded MySQL front but my hosting company says all SQL database management must be done through their web-based PHPmyadmin interface.
Mysql front seems like a faster easier way to convert can I still do this without using my providers default interface?
Thanks
< |
|
|
|
Marcoworld
New Member
Italy
68 Posts |
|
|
Marcoworld
New Member
Italy
68 Posts |
|
|
Cool Surfer
Starting Member
India
32 Posts |
Posted - 19 October 2004 : 13:56:35
|
| can an existing invision forum version2, sql be used with latest snitz forum pl. I desperately need to convert pl.< |
Cool Surfer
 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 17 December 2004 : 06:32:41
|
While it's fresh in my mind thought I'd post this little gotcha on conversions to mySQL.
I did a conversion earlier this week and there were complaints that the badword filter wasn't working correctly afterwards. Turns out they had several filters loaded with a space after the text so that words like assume didn't get filtered. This in itself wasn't an issue. However the field for the badwords in the database is type VARCHAR and theres an interesting "feature" of mySQL that trims all trailing spaces from data in VARCHAR fields, so consequently these filters were no longer working correctly.
Fairly simple fix was to delete that field and redefine it as type text which retains the trailing space (I tried CHAR but for some reason mySQL kept chaing it to VARCHAR even though I had explictly said CHAR in my CREATE statement.)< |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
shaungallant
Starting Member
5 Posts |
Posted - 17 January 2005 : 15:12:11
|
I've converted my access database to mysql, and I'm having a problem with the connect string. I'm hoping someone can point me in the right direction. Currently I'm getting the following error message:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the www.miltonhog.ca home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Provider (0x8000FFFF)
Catastrophic failure
/forum_new/inc_header.asp, line 114
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
GET /forum_new/Default.asp
Time:
Monday, January 17, 2005, 3:03:48 PM
More information:
Microsoft Support
This is my connect string:
strConnString = "driver={MySQL ODBC 3.51 Driver};server=localhost;uid=root;pwd=**********;database=snitz"
Can anyone point me in the right direction?
Thanks,
Shaun< |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 January 2005 : 03:46:44
|
Either of the two provided in the config.asp should work
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
< |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Topic |
|
How I converted my Access DB to mySQL - A guide
