| Author |
 Topic  |
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 24 May 2014 : 15:52:04
|
I did David's Auction mod here. It says an admin is supposed to be able to delete or edit listed items but I'm not seeing where that's possible.
I hate to appear so stupid (no comment! lol), but what am I missing?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 24 May 2014 : 18:17:04
|
| The deletion will only work if the Auction has not finished, then you need to go in to the "Category" that the item is in and you can edit from there. Once the "Auction" has ended, then it cannot be removed or edited, I left it that way as people deserve to see what it sold for or if it did not sell. It should be easy enough to change and will have a look at it this week. |
Cheers,
David Greening |
 |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 24 May 2014 : 19:38:58
|
quote:
Originally posted by Classicmotorcycling
. . .go in to the "Category" that the item is in and you can edit from there.
Oh, I didn't realize I needed to go to "Category" first. I was simply going to the item listed and I quickly saw there was no means of editing it or deleting it from there.
Thank you so much!
I have another question. Members would like to have a "Buy Now" feature. I thought they could simply type "Buy Now!" and type a price in the "Opening Bid" field but that field is strictly numeric. Could that be easily changed? Or, could a "Buy Now" field easily be added?
Here's my auction_sellItem.asp
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 24 May 2014 : 22:00:01
|
I am having a problem when trying to delete an auction item. I receive this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 5.1 Driver][mysqld-5.5.28]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 '* FROM FORUM_AUCTIONITEMS WHERE AUCTIONID=4 AND (SELLER=0 OR SELLER=1)' at line 1
/fp/auction_edititem.asp, line 149
I can edit a listed item without any problem.
Here is line 149:
set rsEdit=my_Conn.Execute(strSql)
In addition, since auction_edititem.asp is a small file, I'll just share the entire file.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 24 May 2014 22:01:54 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 25 May 2014 : 03:25:03
|
Hello MaGraham (and others),
This should now allow for Deletion or Editing from the main Auction page and should of fixed the deletion issue if you was not the seller. I have also allowed Admin's to end the Auction if they feel the need to through the Edit fuction.
New download at: Auction 2.7
Let me know if it don't work as I only have a MS SQL and Access DB to test on at the moment. |
Cheers,
David Greening |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 26 May 2014 : 00:46:32
|
David, I finished the upgrade without any erros. THANK YOU!
If I attempt to edit a listed item (in either the original category area or the new area with the upgrade) I receive the "Please confirm that this is the item you wish to edit" message but there's no place to confirm it (nothing to click on).
And, if I try to delete a listed item I receive this error message.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 5.1 Driver][mysqld-5.5.28]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 '* FROM FORUM_AUCTIONITEMS WHERE AUCTIONID = 1' at line 1
/fp/auction_edititem.asp, line 151
Here is line 151
set rsEdit=my_Conn.Execute(strSql)
And again, since auction_edititem.asp is a small file, I'll just share the entire file.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 26 May 2014 : 05:31:32
|
Hello MaGraham (and others),
Now tested and working with MySQL. Please download the version that I just uploaded then. Let me know how it goes. |
Cheers,
David Greening |
|
|
|
Maxime
Average Member
France
521 Posts |
Posted - 26 May 2014 : 09:06:47
|
Hello David,
You auction_langage.asp page in French please. Otherwise how to create one without making mistakes. I am very bad developer |
Cordially,
Maxime
Taxation consists in so plucking the goose to get the most out of feathers with the least possible cries.(Jean-Baptiste Colbert)
|
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 26 May 2014 : 11:56:22
|
I receive an error when using your link and trying to access the "Auction Mod" download, David.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Maxime
Average Member
France
521 Posts |
Posted - 26 May 2014 : 14:09:50
|
| the site is down snitzbitz.com |
Cordially,
Maxime
Taxation consists in so plucking the goose to get the most out of feathers with the least possible cries.(Jean-Baptiste Colbert)
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 26 May 2014 : 15:55:31
|
Hello MaGraham,
Until SnitzBitz.com is back up, please try this link: Auction 2.7 (revised)
Hello Maxime,
There is a file called auction_language.asp where you can change it to be French as I have no idea on how to translate from English without using Google Translate and that is where all the following came from:
|
Cheers,
David Greening |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 26 May 2014 : 21:24:56
|
Upgrade finished without any errors, David.
When on my admin account, I can edit and delete my items without any problem.
When on a regular member's account, I can edit and delete his/her items without any problem. Meaning, I signed on as a regular member and added items and was able to edit and delete the items.
However; when on my admin account, I am unable to delete a member's item. I can edit a member's item without any problem, but just can't delete it.
Here's the error message I receive when attempting to delete a member's item.
error '80020009'
/fp/auction_edititem.asp, line 166
Here are lines 164-170
Response.Write "<font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHiLiteFontColor & """><b>" & strLang_Auction_00703 & "</font>" & vbNewLine
elseIf Request.Querystring("do") <> "yes" and AuctionID <> 0 Then
Response.Write "<font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strDefaultFontColor & """>" & strLang_Auction_00704 & ": <b>" & rsDeleteName("ITEMNAME") & "</b>?<br />" & vbNewLine & _
"<a href=""auction_edititem.asp?mode=delete&AuctionID=" & AuctionID & "&do=remove"">" & strLang_Auction_00805 & "</a> | <a href=""auction.asp"">" & strLang_Auction_00806 & "</a></font>" & vbNewLine
else
Response.Redirect("auction.asp")
end if
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 26 May 2014 : 23:37:30
|
Try downloading again and just replace the auction_edititem.asp as I had to adjust a little bit.
|
Cheers,
David Greening |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 27 May 2014 : 06:32:27
|
Done.
Same error, on line 166 (80020009), when trying to delete a member's listed item, David.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 27 May 2014 08:42:43 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 27 May 2014 : 15:48:50
|
Here is the one that I tested on which works for me (are you sure that you did not use the previous one?):
|
Cheers,
David Greening |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 27 May 2014 : 16:05:44
|
I downloaded it using your link earlier, David, and it failed to work.
But using what you just now posted, that worked for me.
Thank you so much!
I really do appreciate your hard work on this!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Topic |
|
|
|
