| Author |
 Topic  |
|
cobrachen
Starting Member
48 Posts |
 Posted - 25 December 2008 : 10:05:21
|
This is the first time I received this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-log]Duplicate entry '2-7-12-171' for key 1
/cobrachen/forum/admin_forums.asp, line 489
The command at line 489 is:
my_conn.execute(strsql),,adCmdText + adExecuteNoRecords
The story is: I tried to archive one of my board and I had mismatched error. Then I tried to run it again and received this error.
I could archive the forum and did it after I migrate to MySQL. I also changed some of the columns to use a different data type as suggested in one of the post here. I know the recount function is not working and I am using the SQL statement, also posted here to do it.
Any one has clues to this error?
Thank you very much.< |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 December 2008 : 10:32:30
|
| Previous archive failed and now you have duplicate records on a table, either FORUM_A_TOPICS or FORUM_A_REPLY. You will need to delete the duplicate records, no way around that.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
cobrachen
Starting Member
48 Posts |
Posted - 30 March 2009 : 09:09:32
|
I have tried to archive different boards in my forum several times and all of them failed. I used to have MS SQL Server and never had this problems before. Now I can not archive and have to run my own SQL to clena out those duplicated records.
So far my experience told me that the archive function does not work well with MySQL. Anyone has any solutions or work around? Much appreciate.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 30 March 2009 : 11:33:09
|
| The archive function works the same with all databases. Maybe your web server / db server configuration has changed and that is affecting the archive function. I know a lot of MySQL forums where archiving just proceeds smoothly. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
cobrachen
Starting Member
48 Posts |
Posted - 30 March 2009 : 13:52:48
|
ruirib,
Could you give me some examples of changes that may affect archive process?
Thanks. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
cobrachen
Starting Member
48 Posts |
Posted - 30 March 2009 : 15:56:25
|
How do I change the page timeout from the forum settings without chnage the source code? I can not access the server since I am using a hosting service.
Thanks. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
cobrachen
Starting Member
48 Posts |
Posted - 30 March 2009 : 17:18:33
|
ruirib,
I believe that you mean the changes should make to the page which runs archive process, correct?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
cobrachen
Starting Member
48 Posts |
Posted - 12 April 2009 : 13:52:32
|
I just tried another round with much less record to archive and here is the error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
/cobrachen/forum/admin_forums.asp, line 503
I have to clean out the bad record from the database myself again. If you have any idea of waht happened, much appreciate.
|
|
|
|
SiSL
Average Member
Turkey
671 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 April 2009 : 14:31:14
|
The problem with MySQL engine used in most forums, is that there is no support for transactions, so doing what can be done with SQL Server (the script SiSL is talking about supports that), is not possible.
Anyway, this is a case where the use of Access really limits what we can do, even if we probably would need to have different scripts for different DBs. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
cobrachen
Starting Member
48 Posts |
Posted - 12 April 2009 : 14:39:55
|
So for the archive with MySQL, any suggestions?
|
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 April 2009 : 14:55:22
|
That last error seems a different error, not at timeout thing, not really sure what happened.
I would suggest a forum by forum archive and for a small time period, to minimize the occurrance of errors.
For the reasons explained here, the SQL Server version I wrote is not available. Can't write one for MySQL, not at this moment. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
