Which MySQL version are you using?

hi could you tell me if this will also work with ebay.co.uk

thanks
shaun

I will give you all info from my ISP:

Database: MySQL 4.0.25-standard
PHP Version: 4.4.1 (Zend: 1.3.0)
Server OS: Linux zelter.lunarpages.com 2.4.21-50.ELsmp #1 SMP Mon Jun 11 18:13:29 EDT 2007 i686
HTTP Server: Apache Webserver

Thank you,
Steve

I'm sorry if I'm missing something absolutely obvious, but in version 0.5.3 the install/documentation folder is empty. Am I just thick?

scooper55:

hi could you tell me if this will also work with ebay.co.uk

thanks
shaun

yes this does work with ebay.co.uk you just need to use 3 as the country code when installing

ALP 0.5.3 Installation Instructions

You need to have your eBay Sandbox Keys and Token. If you don't know what this is or don't have them then search on http://auctionlisterpro.com to find the article on how to get them. Please make sure you get a "regular" token not a "REST" token.

1. Download and unzip the latest image of ALP from http://auctionlisterpro.com or http://zen-cart.com
2. Unzip the image to your local hard drive.
3. FTP the files to a folder on your webserver “OUTSIDE” of your web store root, preferably http://www.mystore.com/alp
4. Run the installer located at http://www.mystore.com/alp/install
5. Follow the on screen prompts. If you are not sure what something is then click the question mark (?) for further information.
6. Make sure you specify your shopping cart's database when it asks you for database info.
7. When installation has completed make sure you remove the folder /alp/install

You will need to create an .htpasswd file to protect this installation. When you want to list your products on eBay simply go to http://www.mystore.com/alp

Notes:

• 0.5.4 will have an administrator login so you won't need an .htpasswd file.
• The installer is also being rewritten for clarity and improvements.
• There is a bug with BIN not showing up as successful auction that I am working on to correct. The person is still allowed to purchase the item on eBay.
• There is no checkout redirect/email checkout with the Zen Cart version at this time.

That's very interesting. It should either return a completely blank page or a page with items in it from ended auction.

Can you run this command against your database and tell me what it returns?

This might have to do with the BIN now bug that I am working on.

SELECT * from auction_list;
```> **swiker:**
>
> I will give you all info from my ISP:
> 
> **Database:** MySQL 4.0.25-standard 
> **PHP Version:** 4.4.1 (Zend: 1.3.0) 
> **Server OS:** Linux zelter.lunarpages.com 2.4.21-50.ELsmp #1 SMP Mon Jun 11 18:13:29 EDT 2007 i686   
> **HTTP Server:** Apache Webserver 
> 
> Thank you,
> Steve

maxrisc:

Reinstall ALP and specify your "Cart" database.
I have done all that unless im doing it wrond, ive entered all the details but still comes up with that error??

If you have done that then the DB Prefix is the issue. In /alp/includes/configure.php there should be a line like this but it may be missing.

// define our database connection
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'username');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'mydatabase');
  [B]define('DB_PREFIX',''),  [/B]
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', '');

Put your database prefix in that line including the "_" if there is one.

// define our database connection
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'username');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'mydatabase');
  [B]define('DB_PREFIX','fishkrib_'),  [/B]
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', '');

Save the file and give it a try. Let me know how that works for you.

troy77:

I put all the keys and tokens in and im still getting this:

**1146 - Table 'fishkrib_ebay.configuration' doesn't exist

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]**

:(

A general update on where I am with things as I know it has been a while since I turned out some code.

There is new web based installer which is simplified for installation. I have removed the category installer and I am integrating this into the back end admin so different countries can use it and it will make the initial download smaller.

.htpasswd will no longer be needed and the admin interface has been secured by
username/password which is specified during installation. (There is no automatic reset for this yet so don't lose your passwords)

I have integrated some AJAX functionality into auctions.php and I am adding multiple account support for listing. This will let you manage several accounts and keys from your admin configuration screen. I have toasted the ebay.config.php nightmare that a lot of people have experienced. You will need to add your accounts for testing in your Configuration->Users screen.

I am trying to squeeze in basic shipping information but it might not make it to this next release. We'll see.

There are still some more things to do but hopefully this will be out the door soon. I will be putting it up for testing on my site. Once several people have reviewed it and we have worked out any issues then I will release it for the general public.

And of course documentation....lovely documentation. I am trying to get that sorted as I go along. There are links back to my site where I am compiling everything I have into a book using pages.

Email checkout has been removed from core and put into it's own package. Once 0.5.4 is released email checkout should follow. Hopefully this will be done very quickly as I know there are a lot of xmas sales coming up.

finally got things running on a treat on 1 of my sites but i have just installed it to 1 of my other websites and when i try to select a category to list an item in i get the following error

Fatal error: Call to undefined method EbatNs_ResponseError::getCategoryVersion() in /xxxx//xxxx/public_html/alp/getCategoriesSQL.php on line 65

any idea's whats causeing this?

Usually extra spaces in your ebay.config.php file cause this. Look right after the key entries to make sure that there are none.

Also make sure your token file doesn't have an extra space at the end of the line.

I will be out of town this weekend doing a boat delivery and won't be back until Monday. If you are still having problems I will help you when I get back.

maxrisc:

If you have done that then the DB Prefix is the issue. In /alp/includes/configure.php there should be a line like this but it may be missing.

// define our database connection
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'username');
define('DB_SERVER_PASSWORD', 'password');
define('DB_DATABASE', 'mydatabase');
[B]define('DB_PREFIX',''), [/B]
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', '');

>  
> Put your database prefix in that line including the "_" if there is one.
>  
> ```
 
// define our database connection
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'username');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'mydatabase');
  [B]define('DB_PREFIX','fishkrib_'),  [/B]
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', '');

Save the file and give it a try. Let me know how that works for you.
Sorry but its already done but i reinsalled it all and im still getting the same error.

Any ideas?

This table "configuration" is part of your cart database. If ALP cannot find table configuration then you have done something wrong or your database settings are not correct.

troy77:

I put all the keys and tokens in and im still getting this:

**1146 - Table 'fishkrib_ebay.configuration' doesn't exist

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]**

:(

maxrisc:

That's very interesting. It should either return a completely blank page or a page with items in it from ended auction.

Can you run this command against your database and tell me what it returns?
This might have to do with the BIN now bug that I am working on.

SELECT * from auction_list;

I'm sorry but I do not know what you mean by: Can you run this command against your database and tell me what it returns?

Steve

If you have a program like phpMyAdmin you can run this command against your database using the SQL tab. Your hosting should be able to point you in the right direction with getting this done.

Okay I ran it and then saved the info to a file. Here is the copy/paste of that file. I hope you understand it because it's all greek to me.

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Nov 04, 2007 at 05:21 PM
-- Server version: 4.0.25
-- PHP Version: 4.4.2

-- Database: swiker2_zc1

--
-- Table structure for table auction_list

CREATE TABLE auction_list (
auction_id bigint(20) NOT NULL default '0',
auction_title text NOT NULL,
product_id int(11) NOT NULL default '0',
amount int(11) NOT NULL default '0',
startprice double NOT NULL default '0',
buynowprice double NOT NULL default '0',
buynow tinyint(4) NOT NULL default '0',
sUUID varchar(36) NOT NULL default '',
starttime timestamp(14) NOT NULL,
endtime timestamp(14) NOT NULL default '00000000000000',
bidcount bigint(20) default '0',
bidprice double default '0',
ended tinyint(4) default '0',
PRIMARY KEY (auction_id)
) TYPE=MyISAM;

--
-- Dumping data for table auction_list

INSERT INTO auction_list VALUES (110024735210, '#1 Dad Frame', 1840, 1, 5.35, 10.81, 1, '4211fb8e1acbf294435f41285b60999f', '20071031163450', '20071101163450', 0, 0, 0);

Thanks,
Steve

That looks good. Can you do the same thing for "auction_details"?

I am not sure why the SQL query ( the data ALP is looking for) is not being found. I develop on MySQL version 4.x so this should work.

The search returned zero results.

I have only ran the 1 auction with this on the eBay Sandbox. However, it has ended so I would think this 1 auction should show when I click on "Unsold Auctions'. I checked the database and there are zero records in the table for auction_details.

Thanks,
Steve

That's not good. When an auction is created, the details for it are stored in the auction_details. This is why I asked you to run the second command.

I am currently looking over another issue that just popped up with Buy It Now. It seems that eBay has changed some things and I missed them. This may be why the auction wasn't getting stored correctly. This also is affecting the way things are being returned from eBay and why some sold BIN auctions are showing as failed.

As soon as I reprogram ALP I will post an update along with the updated API toolkit for everyone.