cancel
Showing results for 
Search instead for 
Did you mean: 

Easykiss paypal downloader SQL not importing to Database without errors?

rectro
Dabbler
Posts: 14
Registered: ‎01-05-2008

Easykiss paypal downloader SQL not importing to Database without errors?

I perchased this so I can sell my own products.  Here is the site and video.  I followed the how to install video but somthing is wrong, it wont work. http://paypaldownloadmanager.com/
Mu site is hosted by plusnet which is of course in the htdocs, away from my CGI in which this is for.  So as shown below as example as cant pose my real data, I choose to add the site to that in the config.php file. in the "define ('BASE_URL'" name.
I added what I think is correct in the bottom fields as shown in the video. I did try just "Humbug" without the plus.net not sure which is correct.
$DB_Server = "humbug.plus.net"; //your MySQL Server 
$DB_Username = "name"; //your MySQL User Name
$DB_Password = "password"; //your MySQL Password
$DB_DBName = "name_pn"; //your MySQL Database Name

<?php

define ('BASE_URL', ]'http://ccgi.myname.plus.com');  //your website url goes here like  http://www.yourdomain.com
define ('PAYPAL_LIVE_URL', 'https://www.paypal.com/cgi-bin/webscr'); //This is the live url for paypal - no need to touch this
define ('PAYPAL_SANDBOX_URL', 'https://www.sandbox.paypal.com/cgi-bin/webscr'); //This is the sandbox url for testing the script - no need to touch this

/*
#####################
# These are your database settings #
#####################
*/
$DB_Server = "humbug.plus.net"; //your MySQL Server
$DB_Username = "name"; //your MySQL User Name
$DB_Password = "password"; //your MySQL Password
$DB_DBName = "name_pn"; //your MySQL Database Name
?>

I then uploaded the SQL file in mysql.plus.net, and athough the tabels loaded still, I got this error.

Error
SQL query:
-- -- Dumping data for table `paypal_subscription_info` -- -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE IF NOT EXISTS `products` ( `products_id` int(11) NOT NULL auto_increment, `paypal_email` varchar(250) NOT NULL, `product_name` varchar(250) NOT NULL, `product_amount` decimal(8,2) NOT NULL, `paypal_currency` varchar(10) NOT NULL default 'USD', `button_style` varchar(2000) NOT NULL default 'https://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif', `filename` varchar(250) NOT NULL, `different_filename` varchar(250) NOT NULL, `download_life` int(11) NOT NULL default '1', `thankyou_page` varchar(1000) default NULL, `thankyou_switch` tinyint(1) NOT NULL default '1', `cancelled_page` varchar(1000) default NULL, `cancelled_switch` tinyint(1) NOT NULL default '1', `email_subject` varchar(400) NOT NULL, `email_contents` text NOT NULL, `amount_sold` int(11) NOT NULL default '0', `sand[...]
MySQL said:
#1074 - Column length too big for column 'button_style' (max = 255); use BLOB or TEXT instead
-------------------------------------------------
At shown in the video I can login to my easykiss pannel by using http://ccgi.myname.plus.com//easykissdownloader/login as shown in video, but certain buttons report that certain tables cant be found like when I click settings i get Table 'username_pn.server_stuff' doesn't exist
Any help would be apreciated.
2 REPLIES 2
spraxyt
Superuser
Superuser
Posts: 10,063
Thanks: 1,369
Fixes: 75
Registered: ‎06-04-2007

Re: Easykiss paypal downloader SQL not importing to Database without errors?

Quote from: CGD
Error
SQL query:
-- -- Dumping data for table `paypal_subscription_info` -- -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE IF NOT EXISTS `products` ( `products_id` int(11) NOT NULL auto_increment, `paypal_email` varchar(250) NOT NULL, `product_name` varchar(250) NOT NULL, `product_amount` decimal(8,2) NOT NULL, `paypal_currency` varchar(10) NOT NULL default 'USD', `button_style` varchar(2000) NOT NULL default 'https://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif', `filename` varchar(250) NOT NULL, `different_filename` varchar(250) NOT NULL, `download_life` int(11) NOT NULL default '1', `thankyou_page` varchar(1000) default NULL, `thankyou_switch` tinyint(1) NOT NULL default '1', `cancelled_page` varchar(1000) default NULL, `cancelled_switch` tinyint(1) NOT NULL default '1', `email_subject` varchar(400) NOT NULL, `email_contents` text NOT NULL, `amount_sold` int(11) NOT NULL default '0', `sand[...]
MySQL said:
#1074 - Column length too big for column 'button_style' (max = 255); use BLOB or TEXT instead
-------------------------------------------------

What the error message says is that the maximum length of varchar columns in the current version of MySQL is 255 and the definition highlighted in red exceeds that. (If that one was fixed there are later ones highlighted in blue that would then be picked up. There may be more since the SQL statement is truncated.)
The current version of MySQL is 4.1.11 and version 5.0.3+ is needed to support longer varchars. A MySQL upgrade is being considered but no timescale has been announced. I think it is fair to say it is not imminent.
To see if the application will work on MySQL 4.1.11 you could try replacing `button_style` varchar(2000) with `button_style` varchar(255). For those marked in blue try replacing varchar(...) with text, eg replace `thankyou_page` varchar(1000) with `thankyou_page` text. (I don't think you can substitute 'text' for the red instance because the column has a default value which is not allowed with text.)
There are other differences between MySQL 4 and 5 which might cause the application to fail. Clearly it's up to you whether you wish to try this - and you are dealing with financial transactions. If you do make changes please ensure you retain a copy of the unchanged application code.
Your DB access statements should be OK - either 'humbug' or 'humbug.plus.net' should work.
David
rectro
Dabbler
Posts: 14
Registered: ‎01-05-2008

Re: Easykiss paypal downloader SQL not importing to Database without errors?

Thankyou, all  I had to do was cgange the button to 250 and it sorted it.
Unfortuntaly for me, it looks like this easykiss paypal downloader asumes that your going to store all your files on the same host or server that the php is located in?  I need it to go to my mediafire to send links from there.