| Author |
 Topic  |
|
AnonJr
Moderator
United States
5768 Posts |
 Posted - 05 September 2005 : 13:47:08
|
| What were the last few changes you made? |
 |
|
|
CirruZZ
Starting Member
Sweden
20 Posts |
Posted - 05 September 2005 : 14:07:32
|
quote:
Originally posted by AnonJr
What were the last few changes you made?
The changes I made was those I mentioned above in login.asp.
To see if it is something that I have changed without knowing by mistake, I downloaded and installed a completely new forum (in a different folder), but using the same database. The database is MySQL. The only thing I changed in the new forum was in config.asp, selected MySQL as databes type and then added the connect string.
I still get the same error on the same code in inc_header.asp
if (strSubscription > 0) then
if mlev = 4 and SubCount > 0 then
Response.Write " |" & vbNewline & _
" <a href=""subscription_list.asp?MODE=all""" & dWStatus("See all current subscriptions") & " tabindex=""-1""><acronym title=""See all current subscriptions"">All Subscriptions</acronym></a>" & vbNewline
end if
if MySubCount > 0 then
Response.Write " |" & vbNewline & _
" <a href=""subscription_list.asp""" & dWStatus("See all of your subscriptions") & " tabindex=""-1""><acronym title=""See all of your subscriptions"">My Subscriptions</acronym></a>" & vbNewline
end if
end if
' DEM --> End of Code added to show subscriptions if they exist
Correct me if I’m wrong but doesn't that prove that it isn’t something in the code that have been changed or is wrong. This leads med to the question, can it be the database that have any data that isn’t correct?
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 September 2005 : 14:38:53
|
Hmmm... with the clean installation getting the same results, it sounds like your server is actually checking datatypes. It seems like its not be the changes you made, but maybe some updates the host has made.
I would find where mLev and SubCount are given their most recent values (before the problem comes up) and do a cInt() on them. It definatly looks like it is expecting an integer, but the variables contain a string. That is why the error "moved" when you put the numbers in quotes - you were changing the integers to strings. |
|
|
|
CirruZZ
Starting Member
Sweden
20 Posts |
Posted - 05 September 2005 : 16:35:28
|
| I have found a cause to my error, my server provider made a update to the MySQL server tonight from ver 4.0.x to 4.1.x . That must be the cause! Though still remains what’s wrong with my data base. Can anyone point me in witch direction to look? |
|
|
|
CirruZZ
Starting Member
Sweden
20 Posts |
Posted - 05 September 2005 : 16:44:21
|
I’ve made a SQL-dum of my database structure, sql_dump.txt
I wish I knew what to look for!  |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 September 2005 : 16:50:12
|
I don't think its your database.... but I'm willing to be proven wrong.
According to the SQL dump everything looks like its being stored in the proper datatype. From previous posts you're obviously getting the numbers, its just that it thinks your variable is a string instead of an integer.
Again, I'm willing to be proven wrong. |
|
|
|
CirruZZ
Starting Member
Sweden
20 Posts |
Posted - 05 September 2005 : 17:06:02
|
Ok...so may be...
Going over the hole code and add cInt() seems like a way to solve the problem, but not the right way. I still dont know here the root for the problem/error is. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 September 2005 : 21:39:09
|
| I wouldn't go over the whole codebase (its a bit large), but I would spot-fix any problem areas. |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 06 September 2005 : 05:09:04
|
I had a similar problem with a couple of variables when I upgraded MySQL recently, which is why I made my original suggestion. I doubt it's the database as the problem doesn't seem to be consistent in any way. As far as I remember, there were only 4 variables throughout the whole site that I had to pass through the clng function so going through all your code doing so would probably be a waste of your time, just fix them as they appear and you'll be OK.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Nooky
Starting Member
10 Posts |
Posted - 05 December 2005 : 18:44:19
|
Hey guys..
I figured out the exact same problem after upgrading my SQL Database Server!
I was running my forum for years and it worked fine - after the mysql upgrade something get mixed up with these variable types in the mysql server..
did anybody figure out where to configure the mysql server to behave as it behaved before? |
|
|
|
Nooky
Starting Member
10 Posts |
Posted - 05 December 2005 : 19:24:55
|
Found the solution that should help anybody else here in this thread!
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=55925
Furthermore I figured out - when using ODBC driver in a local machine - when configuring the System-DSN ODBC driver there is a checkbox within the advanced options of the DSN settings with says somethin linke "convert BIGINT to INT"..
this adresses the same problem and fixes it.. if you don't have access to the machine and can not use DSN connecor you have to follow the link to the other topic in this forum: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=55925
there you can place an additional option within the forum connection string that also forces the mysql server to convert BIGINT to INT..
this all is because ADO seems to have a problem with bigint / longlong..
hope this helps you guys also! |
|
|
|
Topic |
|
Topic Locked
