| Author |
 Topic  |
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
 Posted - 03 September 2005 : 16:54:47
|
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.13a-max]Duplicate entry '2-4-7735-142050' for key 1
/forum/admin_forums.asp, line 489
This is the error I am getting when trying to archive topics on my forums. I have done a search here and from which I gather is most likely an empty cell in the database? is that correct?
If so how can I go about fixing this? |
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 03 September 2005 : 18:17:11
|
Its ok, I have sorted it.
I made my own php script to delete old posts past a certain date. And that seems to have fixed the error. (probably took out the post that was causing it! |
 |
|
|
secretsquirrel
New Member
Australia
81 Posts |
Posted - 04 May 2006 : 14:30:41
|
I just got an error in the same line while trying to archive.
ADODB.Connection.1 error '80004005'
SQLState: S1000
Native Error Code: 1062
[TCX][MyODBC]Duplicate entry '2-19-70-457' for key 1
/forum/admin_forums.asp, line 489
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 May 2006 : 14:37:11
|
| That possibly happens because you are trying to archive after some previously failed archiving attempt. Unless you can find your way using MySQL, there isn't much you can do, except deleting old archived posts, but you have no easy way of knowing which ones to delete, except through MySQL... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
secretsquirrel
New Member
Australia
81 Posts |
Posted - 05 May 2006 : 00:15:17
|
Thanks Ruirib. I did have a failed archive attempt with that part of the forum once before. Fortunately it's not one of the main parts of the forum so i can play around with it a bit.
MySQL hehe i have no idea what i'm doing with it so won't go there 
I will take my time and move threads that fall into the time frame i'm attempting to archive to another part of the forum and bring them back bit by bit archiving as i go until i get the message again.
Thanks for the help |
|
|
|
secretsquirrel
New Member
Australia
81 Posts |
Posted - 15 May 2006 : 23:44:40
|
Now i get this  Couldn't find anything on this error in search.
ADODB.Connection.1 error '80004005'
SQLState: S1090
Native Error Code: 0
[TCX][MyODBC]SQLBindParameter not used for all parameters
/forum/admin_forums.asp, line 489
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 10 April 2008 : 04:54:40
|
quote:
Originally posted by ruirib
That possibly happens because you are trying to archive after some previously failed archiving attempt. Unless you can find your way using MySQL, there isn't much you can do, except deleting old archived posts, but you have no easy way of knowing which ones to delete, except through MySQL...
Hi ruirib - Would you mind giving me a string or an idea what I would be looking for in the MySQL I do use MySQL-FRONT and can run scripts. I have the exact problem stated here but am unsure how to overcome it.
I have successfully archived many of my topics, however there are approximately 12 topics which are original and I seem to recall having an archive problem in the early days, I do have monthly backups, I can provide copies of entire database or even a single topic (even a very small topic) if it could help to pinpoint what I need to look for.
NiteOwl |
Edited by - NiteOwl on 10 April 2008 06:00:04 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 10 April 2008 : 09:38:16
|
I get the following error:
SHOW FIELDS FROM `forum_reply`
SHOW KEYS FROM `forum_reply`
DELETE AR FROM FORUM_REPLY R INNER JOIN FORUM_A_REPLY AR ON R.REPLY_ID=AR.REPLY_ID
Not unique table/alias: 'ar'
|
-=NiteOwl=-
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 April 2008 : 10:01:13
|
Well that looks like an issue with your MySQLFront. I ran this on SQLYog and it went ok.
Do yourself a favor and download the free version of SQLYog. Beats MySQLFront any day. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 10 April 2008 : 14:23:24
|
ok, I do remember looking at this product before and I even have it loaded on my machine. Here si the error I am getting now:
Error Code : 1066
Not unique table/alias: 'ar'
(0 ms taken)
I maybe trying to run it incorrectly as I am not familure with product, I have selected the forum_reply on the left then run the sql query provided. . I also tried running it from the top of the database...I must be doing something wrong? OH and of course this is on my recent backup.
|
Edited by - NiteOwl on 10 April 2008 14:31:14 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 April 2008 : 14:48:49
|
What version of MySQL are you running locally?
I'm running this on MySQL 5.x and have no issues running it. It works as expected. This also runs perfectly on MySQL 4.1.x, so maybe try it at the live server, because it won't delete anything that's not repeated. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 10 April 2008 : 15:34:59
|
ok I will try to run it on the live server, that may well be the problem as my backup server is my home machine windows-server and something I have always noted is that the live server is always uppercase and when I do my backups to my personal server it all goes to lower-case.
Home windows-based server version 3.23.38 :( its been there a long time.
My production is running on a Linux box. Not sure the version but its hosted professionally, I have to run to work, but when I get back I will take the forum down and try running the sql on the live database. Thanks for your quick response I do so much appreciate it.
-=Bob=-
|
-=NiteOwl=-
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 11 April 2008 : 01:59:06
|
Crap - I just realized my host is providing me with MySQL 3 its actually not surprisingly as that is what I desired 5 years ago and they would not change me without notification. (I never thought of that)
So I would like to upgrade but I do have a pressing problem with response time now and need to do an archive especially on the busiest forum. Is there something else we can do to get me out of the hole, at which time I can work with my provider my personal machine to do an upgrade? |
Edited by - NiteOwl on 11 April 2008 02:13:36 |
|
|
|
Topic |
|
Topic Locked
