| Author |
 Topic  |
|
modifichicci
Average Member
Italy
787 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
 Posted - 19 March 2006 : 09:51:35
|
quote:
Originally posted by ruirib
I find it hard to accept that a newly created MySQL DB locks up when you try to access member info. Never saw anything like that and it makes me suspicious. I am a pessimist by nature  .
I can understand that completely. I ask because I'm trying to learn as much as I can about SQL Server and MySQL before I need the knowledge.  And this place has been the best place to learn. |
 |
|
|
trevally
Starting Member
46 Posts |
Posted - 19 March 2006 : 20:33:12
|
Solved! System performance back to normal!
Ruirib, I used your code recommended in the other link but it made no difference. Then I saw OneWayMule who wrote to disable Recent Topics in the member's feature configuration. I did that and everything went back to normal!!!! If you visit my forum www.fishing.net.my/forum and just click now on any members the pop up profile is quick.
This is so baffling. Why does recent topic cause the system to slow? I have already cleaned up all the tables for dups or null.
Secondly, another problem crept up. I tried to archive for stuff more than 1 month, now I get this new problem:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
/forum/admin_forums.asp, line 503
Is this error somehow related to Mysql? I never got this in Access.
Anyway, I am happy that the main forum is back to normal.
Thank you!
Vincent |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 March 2006 : 05:32:16
|
ODBC is the layer of code used by ASP to connect to your database. There is either a web server problem causing that, or a MySQL problem that then causes an issue with the driver. Either way, as I wrote before, I wouldn't trust that server very much.
You can always ask your host to make sure they have the latest MyODBC version installed. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
trevally
Starting Member
46 Posts |
Posted - 20 March 2006 : 09:04:59
|
I just checked with them. It is 3.51. Is it okay?
Thanks,
Vincent |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 20 March 2006 : 23:34:42
|
| There are something like 15 point releases for 3.51 .. if it's older < 3.51.7 or so, that could be a source of some issues, I think the current version is about 3.51.15 or thereabouts. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
trevally
Starting Member
46 Posts |
Posted - 21 March 2006 : 01:43:48
|
This is the connection string from my config.asp
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=localhost;user=test;password=test;DATABASE=snitz;" '##MySQL w/ MyODBC v3.51
This is the correct one right? Just find it strange that it works in Access but now not here.
Vincent |
Edited by - trevally on 21 March 2006 05:38:10 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 March 2006 : 07:39:15
|
| Yeah, that is the correct connection string. I would suggest that you check Gremlin's advice on the post above and check with your host about the current version of MyODBC... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
trevally
Starting Member
46 Posts |
Posted - 21 March 2006 : 09:37:01
|
Ruirib and Gremlin,
Can I check with you on one last matter. I promise to buy you guys beer when you come over to Malaysia.
Since I know I am getting close to this matter, is there some SQL commands that I can use to go through each table to see which one is not responding correctly? Is there any test query scripts you are aware of that I can cut-and-paste inside the Myphpadmin SQL section for this?
Thanks for any last advise on this.
Regards,
Vincent |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
trevally
Starting Member
46 Posts |
Posted - 21 March 2006 : 11:35:51
|
Where do I add this code to?
Thank you.
Cheers,
Vincent |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 22 March 2006 : 01:47:37
|
| Your admin section will also show you the exact MyODBC version your server is running, you'll find it near the bottom of the "Server Information" page called Driver Version. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
trevally
Starting Member
46 Posts |
Posted - 22 March 2006 : 22:56:20
|
Hi Gremlin,
This is what I got:
Driver Name myodbc3.dll
Driver Version 03.51.11
Driver ODBC Version 03.51
Are these okay? Or is this version causing problems for me?
Thanks,
Vincent |
|
|
|
Topic |
|
Topic Locked
