| Author |
 Topic  |
|
s80ts0465
Junior Member
Italy
290 Posts |
 Posted - 09 February 2009 : 12:35:58
|
I've recently decided to migrate from Access to Mysql 5.1.22
I converted the old access database using the migrating tool of Mysql.
I changed, i think correctly, the config.asp.
The default.asp page works correctly, but as soon as i want to open any folder (forum.asp) i get the following error:
run-time error Microsoft VBScript (0x800A000D)
Tipo non corrispondente
/logbook/forum.asp, line 313
if strDBType = "mysql" then 'MySql specific code
if mypage > 1 then
intOffset = cLng((mypage-1) * strPageSize)
strSql5 = strSql5 & " LIMIT " & intOffset & ", " & strPageSize & " "
end if
'## Forum_SQL - Get the total pagecount
strSql1 = "SELECT COUNT(TOPIC_ID) AS PAGECOUNT "
set rsCount = my_Conn.Execute(strSql1 & strSql2 & strSql3)
iPageTotal = rsCount(0).value
rsCount.close
set rsCount = nothing
line313 If iPageTotal > 0 then
inttotaltopics = iPageTotal
maxpages = (iPageTotal \ strPageSize )
if iPageTotal mod strPageSize <> 0 then
maxpages = maxpages + 1
end if
if iPageTotal < (strPageSize + 1) then
intGetRows = iPageTotal
elseif (mypage * strPageSize) > iPageTotal then
intGetRows = strPageSize - ((mypage * strPageSize) - iPageTotal)
else
intGetRows = strPageSize
end if
else
iPageTotal = 0
inttotaltopics = iPageTotal
maxpages = 0
end if
if iPageTotal > 0 then
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql & strSql2 & strSql3 & strSql4 & strSql5, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
arrTopicData = rs.GetRows(intGetRows)
iTopicCount = UBound(arrTopicData, 2)
rs.close
set rs = nothing
else
iTopicCount = ""
end if
else 'end MySql specific code
< |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 09 February 2009 : 14:36:41
|
sorry i haven't seen it before.
Tomorrow i'll try it.
thanks a lot< |
 |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 20 February 2009 : 11:11:52
|
I've tryed but i can't export the datas from the Access DB.
I use Access2007.
Any suggest??
I'd like to convert to MySQL, beacuse i'd like to use the forum under Linux OS. Do you think that is pssible to use the Access DB under Linux OS (Kubuntu)?< |
Edited by - s80ts0465 on 20 February 2009 11:17:45 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 February 2009 : 13:24:25
|
| No, Access can't be used under Linux, as far as I know. There are a lot of posts in the MySQL forum on how to migrate from Access to MySQL. Did you try to have a look?< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 February 2009 : 04:09:54
|
i tryed all the options but with any good results.
For the first procedure in the first post i get an error exporting the data from access to csv file.
and using Mysql front i get errors importing data into the forum_TOPIC table.
Anyway something works, in fact the default.asp page works fine and it shows me correctly all the category, but when ienter in the forum.asp file i get erors as reported in my first post here.
But would be possible that someone send me the backup of a Mysql-Snitz forum so i can directly create it in my server? could it work??< |
|
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 February 2009 : 04:23:13
|
i've just found out that the problem was in the comma, now i'm able to extract the datas using the semicolon that then i'll change in comma.
anyway is it possible that someone send me the backup of a Mysql-Snitz forum so i can directly create it in my server? could it work??
ps but with the complete versione of Access-to-MySQL program is it possible to convert all datas directly to mysql with any prblem?? I mean the trial versione makes the job, but only for 5 rows per table,and so i think that the complete version does the conversion for the all rows. On this ways all the job of extractinig dats andimporting in mysql shouldn't be necessary to do. is it correct?< |
Edited by - s80ts0465 on 21 February 2009 04:30:13 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 February 2009 : 06:56:09
|
| |
Edited by - s80ts0465 on 21 February 2009 07:08:59 |
|
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 February 2009 : 07:18:11
|
| |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 February 2009 : 09:10:26
|
thanks, right now i'm able to complete the creation of the MySQL database using the snitz forum setup.asp
Anyway when i go the default.asp page i get some errors about the necessary table for the mods, like whoisonline, imagerotator, ect.
How to solve it?? is for these mods just necessary to create the table and so on??? or what??< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 February 2009 : 12:45:52
|
ok.
I'm using the image snitz mod forum, and the setup.asp doesn't install everything! I've seen that if i insert manually all the column the are missed during the setup.asp installation the forum starts to work.
Is there a faster mode to install the dbs?< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 February 2009 : 13:21:34
|
| I am sorry, we don't provide support to Image's code. You will have to ask on his forums, but make sure you use a different password from the one here, he has hijacked quite a few accounts of members who used the same data here and at his forums.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 February 2009 : 13:48:48
|
yes exact. In fact after the last post i tryed to connect to image forum and it seems impossible even if i use the normal username and password. I'll create a new account. Strange.
Anyway many many thanks you really helped me a lot!!!< |
|
|
|
Topic |
|
Topic Locked
