| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
 Posted - 20 April 2008 : 18:34:01
|
I've just tried ruirib's suggested file and received the folowing error when deleting a members reply to a post:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias 'T_VALUE' in query definition's SELECT list.
/forum/pop_delete.asp, line 127
< |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 20 April 2008 : 18:43:06
|
| okay reverted back to original file.. thanks andy< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 21 April 2008 : 04:28:41
|
| Thank you, will you so kindly be adding the topic code?< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2008 : 04:36:46
|
quote:
Originally posted by Andy Humm
Thank you, will you so kindly be adding the topic code?
Well, this is modifichicci's mod, I'm just helping out. With the examples given, I think he will be able to provide the code for the topics. If not, I may find some time later in the week to get acquainted with the code, which I really am not at the moment.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Andy Humm
Average Member
United Kingdom
908 Posts |
Posted - 21 April 2008 : 05:05:40
|
| Roger, that's copied! Thank you for your valuable input!< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 21 April 2008 : 12:46:00
|
Thank for help, I am sure I need it a lot!!!
With your code I receive the same error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.27-standard-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX(T_DATE) AS T_VALUE FROM FORUM_TOPICS WHERE T_AUTHOR
on deleting reply. ( and on deleting topic also, if can help..)
The file is your file
I cannot understand what is the issue.. I am blockhead I am afraid..< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 April 2008 : 16:07:01
|
| Can it be that MySQL 4.0 does not support the syntax? I can only access 4.1 and 5.x versions... If your server allows remote access and you don't mind sending me the access data, I may try the query from SQLYog.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Topic |
|
Decrease members post count on post deletion
