Major Additions - microAUCTIONS (Auction Classifieds)

*** Link Removed ***

[WhiskeyOSS]

Every time a item is posted and someone attempts to view this item we get this error message I have uninstalled this hack till this is resolved as I was unable to remove the items from the listings.


Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT * FROM microauctions_item_hits WHERE itemid=4;

MySQL Error : Incorrect information in file: './mtoler_OSSAuctions/microauctions_item_hits.frm'
Error Number : 1033
Request Date : Tuesday, June 8th 2010 @ 04:21:13 PM
Error Date : Tuesday, June 8th 2010 @ 04:21:28 PM
Script : http://www.oldschoolshooters.net/OSS...witem&itemid=4
Referrer : http://www.oldschoolshooters.net/OSS...o=main&catid=8
IP Address : 24.100.76.46
Username :
Classname : vB_Database
MySQL Version : 5.1.46

[WhiskeyOSS]

I Had to uninstall do to error issues Now its a nightmare of error issues its not on my site any longer (uninstalled) but yet I keep getting these errors over and over NEED SOME HELP HERE The catagory listed in the error below DOES NOT EXIST from what I can see..

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_microauctions AS phrasegroup_microauctions,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_posting AS phrasegroup_posting,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_microauctions' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Error Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Script : http://www.oldschoolshooters.net/OSS...=main&catid=20
Referrer :
IP Address : 66.249.71.236
Username :
Classname : vB_Database

For a temp fix to stop the sql errors I removed auctions.php from the data base now it just gives a page not found error.

[rtyagis]

Reserved. Thanks !:up:

[WhiskeyOSS]

Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?

[WhiskeyOSS]

Originally Posted by MicroHellas

Just one spelling error?? ..lol.. Then it seems that I've improved my English. Don't forget that English is not my mothertongue. You can edit all phrases from phrase manager at your admincp.

Maria

Originally Posted by WhiskeyOSS

When I tried to use an ' (apostrophe) in a sub catagory listing I kept getting this error message got any Idea's as to why ?

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO microauctions_categories
SET name='CPU's New and Used',
displayorder='0',
parentid='1';

MySQL Error : 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 's New and Used',
displayorder='0',
' at line 2
Error Number : 1064
Request Date : Monday, June 7th 2010 @ 11:03:39 PM

Originally Posted by WhiskeyOSS

Every time a item is posted and someone attempts to view this item we get this error message I have uninstalled this hack till this is resolved as I was unable to remove the items from the listings.


Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT * FROM microauctions_item_hits WHERE itemid=4;

MySQL Error : Incorrect information in file: './mtoler_OSSAuctions/microauctions_item_hits.frm'
Error Number : 1033
Request Date : Tuesday, June 8th 2010 @ 04:21:13 PM
Error Date : Tuesday, June 8th 2010 @ 04:21:28 PM
Script : http://www.oldschoolshooters.net/OSS...witem&itemid=4
Referrer : http://www.oldschoolshooters.net/OSS...o=main&catid=8
IP Address : 24.100.76.46
Username :
Classname : vB_Database
MySQL Version : 5.1.46

Originally Posted by WhiskeyOSS

I Had to uninstall do to error issues Now its a nightmare of error issues its not on my site any longer (uninstalled) but yet I keep getting these errors over and over NEED SOME HELP HERE The catagory listed in the error below DOES NOT EXIST from what I can see..

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_microauctions AS phrasegroup_microauctions,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_posting AS phrasegroup_posting,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_microauctions' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Error Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Script : http://www.oldschoolshooters.net/OSS...=main&catid=20
Referrer :
IP Address : 66.249.71.236
Username :
Classname : vB_Database

For a temp fix to stop the sql errors I removed auctions.php from the data base now it just gives a page not found error.

Originally Posted by WhiskeyOSS

Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?

WhiskeyOSS;2053432]Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?

[Wilfred1]

I have no choice but to post this here as the developers site won't allow for a "Contact Us" or allow for PMs to be sent to Maria which is a bit concerning if one is to pay money for something.

Hi Maria
Just registered on your site

I am very interested in purchasing your classifieds product however I have been bitten several times (eg vbClassifieds) in the past and I am concerned that in the past you have packed up shop and went away - your site even closed down. Can you give any type of assurance this won't happen again - not trying to be nasty but just trying to be careful. Your products have great concepts behind them so well done.

I am also confused - in vb.org you have Classifieds and Auctions - on your site you just have Classifieds - is the Classifieds product there the joining of both the Classifieds and Auctions products that are here on vb.org?

I am after a Classifieds products with the ability for just the odd auction, i.e. 98% of entries will be classifieds and just a few Auctions so which is the best option for my site?

Incidentally, your site is so slow - I use to use COMODO Certificate on my site which really slowed it down so I removed it and just made it on the actual checkout of my site and the site came back to being fast.

There seems to be a lot of styling issues on your demo site of the Classifieds product - what is the development plan to fix the many issues that are being experienced with your products including the ability to use the vb inbuilt attachment facility etc.

Thanks for your help in answering these questions and I hope I can support you and your products

[RickyG]

Anyone using this on a VB4 site? I know it is in the VB4 area....but Any issues?

[WhiskeyOSS]

Originally Posted by RickyG

Anyone using this on a VB4 site? I know it is in the VB4 area....but Any issues?

Yeah I have it installed but it does seem to have issues.. that cause data base errors and such asked for help but never got it..

[MaryTheG(r)eek]

Originally Posted by WhiskeyOSS

Yeah I have it installed but it does seem to have issues.. that cause data base errors and such asked for help but never got it..

What issued did you had? Works fine witn 4.x

Maria

[KissOfDeath]

I've installed it and have a couple of issues,

first one, no decimals, say i want to put a bid price of 5.50 or 5.(anything here) it rounds it up or down to 5,

Second issue is that the images attached to auctions don't upload, auction saved and when you open it their are no images,

Not sure if its because i'm using ImageMagick 6 as my Image Processing Library?