Topic: JBidwatcher Development / Query for lost auctions, and other DB sundries...

Hi Morgan et al,

For quite some time, there’s been an issue starting up jbidwatcher. On my initial installation, it used to take anywhere up to 30 minutes or even more, pinning the CPU in the process. I’ve seen others on the forums make mention of this…

Figuring that I’ve been using this thing for years now and thought I’d give a little something back, I think I’ve tracked down the problem. Specifically, the qurey in findLostAuctions() in AuctionInfo. If you have a rather large auctions table (mine seems to have about a 1.4m rows), the existing query creates one heck of a cartesian product. Try it interactively.

So… To fix this, I propose using this query instead.

SELECT * FROM auctions a WHERE NOT EXISTS ( SELECT 1 from entries e where ( a.identifier = e.identifier ))

which seems to work quite nicely and still returns the same result. Tested with both Derby and MySQL.

And… Startup time is now “normal” once again.

Oh, and while I’m at it, I’ve looked at the DB creation script (jbidwatcher.sql) which fails for MySQL/MariaDB…

Specifically, when you create the devices table. That’s not a valid syntax for that under those DBs (and others).

The corrected syntax for those, would be:

CREATE TABLE devices (
id INTEGER NOT NULL AUTO_INCREMENT,
device_id VARCHAR DEFAULT NULL,
security_key VARCHAR DEFAULT NULL,
PRIMARY KEY (id)
)

ALTER TABLE devices AUTO_INCREMENT = 1

The alter table is sort of “redundant” but since the original statement specified a starting value…

I’ve tested both of these with the latest source from github…

So, I propose that perhaps you could fire off a separate script when initializing different DBs?

And also, making reloading DB from the auctions.xml file work again, would be kind of nice… It seems to be broken (also mentioned on the forums). I’d be willing to take a look at that as well.

Hope that helps out a bit and thanks!

Topic: JBidwatcher Help / Time Left is N/A for all items

I added two new items to my Watch list. When I refreshed JBidwather, they showed up with the correct Time Left.

— Ward

Topic: JBidwatcher Help / Only 25 items imported from My eBay

Hello,

I have just upgraded to the new version of the program, but I had the same issue with previous versions.

Basically, when importing items from My eBay into the “Current” column, JBidwatcher will only retrieve the first 25 auctions in my watch list. When I try and manually retrieve more, it says there are no more.

Am I missing a setting to change, or should there be more than 25 auctions retrieved?

Thanks.

Topic: JBidwatcher Help / OK been running 2.56 bit 2/99 fails

Hello fellow users… OK so 2.99 pre5 does not install windows XP… fails as stated above. I’ve had luck with 2.56 for a long time but lately it either snipes perfectly or does not even attempt to send the snipe???

OK so lets look at the log and find out what’s up… There is no log! There used to be but I have NO idea where it’s going. I have my path set up for the C:\Program Files\JBidwatcher\auctions.xml but even that is already over 2 months behind… so I do have the auctions.xml file but its last entry was March 2016… this is May 2016. The log file that used to record the process is long gone and is not in the C:\Program Files\JBidwatcher\ folder nor is it in my C:\Documents and Settings\username\Application Data\ which is where I usually look as an alternate location.

Any ideas on either my 2.56 problem or my lack of being able to install my 2.99 pre5? THANK YOU TO ALL!

Topic: JBidwatcher Help / OK been running 2.56 bit 2/99 fails

What’s up with the new 2.99 pre5 installer into XP? Running XP. I’ve done a lot of test work and reported in the past… Trying to install 2.99 and fails here: Unable to write to C:\Program Files\CyberFOXSoftware\JBidwatcher\jre8\bin\client\jvm.dll …

Yes the original program was not active at all but not uninstalled? Any ideas?

Topic: JBidwatcher Help / Time Left is N/A for all items

After setting up several eBay watches, I activated JBidwatcher 2.99pre5. It had been idle for a month or more.

When I noticed this latest release was displaying Time Left as “N/A” for all items, I reverted to 2.5.6-11. This older release has the same problem.

I’m running JBidwatcher on OS X 10.5.5.

— Ward

Topic: JBidwatcher Help / force JBidwatcher to re-import auctions.xml

Updating to add that rebuilding the database also works in 2.1.6. It does not work on any version after 2.5. I strongly encourage all JBidWatcher users retain one of these pre-2.5 versions of the program in the event that you need to rebuild your derby database. And I’ll re-iterate my request to have this feature as a menu item in future versions of the program.

Topic: JBidwatcher Development / running from eclipse

In IntelliJ IDEA Community Edition, mark the resources folder as a Resource Root (right click folder and choose Mark Directory as"

Topic: JBidwatcher Help / force JBidwatcher to re-import auctions.xml

Hi,
This won’t help you but I vote for your request to get a menu item to import csv files. Not exclusively for the current tab but for all the tabs, standard and added ones.

Topic: JBidwatcher Help / no more thumbnails ?

Hi,

10 days ago, I updated Java from Ver. 8 update 51 (build 1.8.0_51-b16) to Ver. 8 update 77 (build 1.8.0_77-b03).
I then had random issues with the thumbnails that were playing hide and seek.
Yesterday I noticed that none of the new entries had any thumbnails.
I don’t know if this java related or not.

Any clue about what to look for ?

Thanks in advance and best regards

Topic: JBidwatcher Help / Installing on windows 10

I installed 2.99 to windows 7 successfully but when installed to windows 10
refreshing logged on correctly but only obtained items circa 2014 obviously out of date and no current items.
uninstalled old version 2.56 and 2.9 from the control panel reinstalled 2.99 with the same result
-ancient items only.
Searched the computer and found a hidden folder .jbidwatcher in:
c:\users\your user name\.jbidwatcher -dated 2014

Solution
uninstalled 2.99 again then deleted the above folder in that location.
rebooted reinstalled from scratch entered ebay user name password etc. refreshed
and got the uptodate info correctly.

obviously uninstall does not clear out this old data which interfers with the latest version
Dont no why some words have a line through them

Topic: JBidwatcher Help / 2.5.6 Bug - Fails to pull shipping costs

Yup. I’m using v. 299.pre5. It is pulling in shipping costs from Canada, but not from China or the USA.

Is there another setting for shipping costs other than the “shipping column”?

Topic: JBidwatcher Tips and Tricks / Shipping Column and search

I don’t have an answer, but I too am interested in a Shipping Cost column. However, I haven’t stumbled across instruction on how to activate a shipping column.

Any help out there?

Topic: JBidwatcher Help / Error message just started appearing

No, I’m not being prompted for anything. Logging in and out from browser works fine.

Undoubtedly, eBay has changed something again.

Topic: JBidwatcher Help / Error message just started appearing

Are you being prompted to update your personal information? Try logging out and back in from your browser.

Topic: JBidwatcher Help / Error message just started appearing

“The login did not cause any errors and delivered cookies, but was not clearly recognized as successful.”

This message just started appearing from JBW. Version 2.99pre5-2-g7251940.

Login icon on JBW screen is yellow, not green as usual.

Ideas?

Topic: Announcements / Can't download?

Thank you, Morgan!!!!!!!!! Got it downloaded AND installed.

Topic: Announcements / Download server failure

Thank you for resolving this. I was able to successfully download the files.
Cheers!

Topic: Announcements / Can't download?

Thank you, success!

Topic: JBidwatcher Help / 500 error on update file

Nothing to be sorry about… not nearly as much of a problem as having an option to disable time sync that doesn’t!

Thanks again,
—Bushytails

Topic: JBidwatcher Development / 10.8+ Is there a real reason?

Greetings,
I wrote a post on the reasons why which might help some.

I don’t like leaving older systems behind either, but the combination of upcoming security issues and the Apple/Oracle transition of who owns Mac Java have really made it hard to do anything but a clean break.

In this case, I’m fairly sure that the upgrade to 10.8 as a minimum requirement is pretty well-founded.

— Morgan

Topic: JBidwatcher Help / 500 error on update file

Greetings,
My database went absolutely nuts; somehow it started repeating what were supposed to be unique, auto-incremented primary key ids, which prevented a whole bunch of things from working. :(

It’s fixed now… Sorry about that.

— Morgan

Topic: Announcements / Can't download?

Greetings,
Sorry, my back-end database went wonky, started repeating a series of supposedly unique ids, which prevented the download. :(

I’ve fixed it; it should be working again.

— Morgan

Topic: Announcements / Download server failure

No files can be downloaded. Here is the error message:

This site can’t be reached

The webpage at https://www.jbidwatcher.com/download/JBidwatcher-2.99pre5-Installer.exe might be temporarily down or it may have moved permanently to a new web address.

ERR_INVALID_RESPONSE

Topic: Announcements / Can't download?

I get the same thing — unable to download anything.

I even tried to go to the download page — not even an index, so there’s obviously some sort of problem. Hope it gets fixed soon.