Looking for something? Try the following:

  1. Visit Our New Tracking202 Support Center & Forum
  2. Read The Proper202 & Tracking202 FAQ
  3. Search This Old Forum
INstall Error
Post new topic Reply to topic Prosper202 Forum Index » Prosper202 General Discussion
New Posts Search Forum
Author Message
profezor


Joined: Mar 27th, 2008
Posts: 24

Post Posted: Apr 29th, 2008 at 12:58pm Post subject: INstall Error Reply with quote

"There doesn't seem to be a 202-config.php file. I need this before we can get started. Need more help? Contact Us. You can create a 202-config.php file through a web interface, but this doesn't work for all server setups. The safest way is to manually create the file."

Is the first error. Why? I transferred all the files.

Second error.

"Sorry, I can't write to the directory. You'll have to either change the permissions on your Prosper202 directory or create your 202-config.php manually."

There is no Prosper directory because we are at root.

So, where od I get this config file? Where do I put it when I have it

Thanks

Back to top
profezor


Joined: Mar 27th, 2008
Posts: 24

Post Posted: Apr 29th, 2008 at 1:16pm Post subject: Re: INstall Error Reply with quote

P.S. If I can't get some help on this. I will pay someone here to install, if they can guarantee it will be working and can do it quickly.

profezor wrote:
"There doesn't seem to be a 202-config.php file. I need this before we can get started. Need more help? Contact Us. You can create a 202-config.php file through a web interface, but this doesn't work for all server setups. The safest way is to manually create the file."

Is the first error. Why? I transferred all the files.

Second error.

"Sorry, I can't write to the directory. You'll have to either change the permissions on your Prosper202 directory or create your 202-config.php manually."

There is no Prosper directory because we are at root.

So, where od I get this config file? Where do I put it when I have it

Thanks

Back to top
profezor


Joined: Mar 27th, 2008
Posts: 24

Post Posted: Apr 29th, 2008 at 1:39pm Post subject: Re: Install Error Reply with quote

Modified the config-sample file. Now I get a database error. I checked the mysql server and even restarted the entire mysql server on my dedicated box. The database and password are good. So why the error still?

Back to top
T202Steven
Website Email


Joined: Dec 4th, 2007
Posts: 2400

Post Posted: Apr 29th, 2008 at 2:55pm Post subject: Re: INstall Error Reply with quote

We don't need you to pay. What you need to do is to create the 202-config.php file. Basically edit the 202-config-sample with your info, and then save the file as 202-config.php without saving over the sample file. This should essentially get your account working correctly.

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 4437

Post Posted: Apr 29th, 2008 at 6:56pm Post subject: Re: INstall Error Reply with quote

profezor wrote:
Modified the config-sample file. Now I get a database error. I checked the mysql server and even restarted the entire mysql server on my dedicated box. The database and password are good. So why the error still?

What one said is correct. You are almost there.

The 202-config-sample.php is a sample file. What you want to do is edit the file, and then save it as 202-config.php, now it should work for you, as long as the database host,user,pass,database_name (all 4) are correct. It'll connect!

You basically got it, just save it as, 202-config.php instead of 202-config-sample.php.

Back to top
profezor


Joined: Mar 27th, 2008
Posts: 24

Post Posted: Apr 29th, 2008 at 10:26pm Post subject: Re: INstall Error Reply with quote

yes, of course I did that. Same error.

As I said below after double checking the database info and restarting the ENTIRE MYSQL server in the machine.

I just saved the sameple as the config file.

So I did save over the old file , although witha different name.

Next I will create a totally new config file.

BTW, why did not the config file come with teh zip anyway?

Back to top
cpamelvin
Website Email Twitter Facebook Skype GTalk
MSN AIM


Joined: Feb 8th, 2008
Posts: 188

Post Posted: Apr 29th, 2008 at 11:50pm Post subject: Re: INstall Error Reply with quote

Hi,

Are you using host gator as your provider? If yes, I have created a video on the installation. The steps are more or less the same with other providers as well. Try watching it and see if it solves your problem on the config file. The download link is here > http://www.tanmelvin.com/Prosper202installationvideo.zip

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 4437

Post Posted: Apr 30th, 2008 at 12:13am Post subject: Re: INstall Error Reply with quote

profezor wrote:
yes, of course I did that. Same error.

As I said below after double checking the database info and restarting the ENTIRE MYSQL server in the machine.

I just saved the sameple as the config file.

So I did save over the old file , although witha different name.

Next I will create a totally new config file.

BTW, why did not the config file come with teh zip anyway?

what is the filename, of the new config file you named it. Is it 202-config.php, in the root folder with all the other files?

If the 202-config.php file is there, it should goto the next step. Does it say its still not there, even though you created it?

Could it be due to your permissions. Earlier it reported, ""Sorry, I can't write to the directory. You'll have to either change the permissions on your Prosper202 directory or create your 202-config.php manually." you said. What is the CHMOD on those guys, can we change the CHMOD on the folders/files to 777 or something to make it work.

What host are you using, and what FTP client are you using, what is the default uploading CHMOD settings for the FTP client? Sometimes it can upload files inaccessible because the FTP client uploads to a default CHMOD which is unreadable.

Back to top
profezor


Joined: Mar 27th, 2008
Posts: 24

Post Posted: Apr 30th, 2008 at 5:15am Post subject: Re: INstall Error Reply with quote

No, I am not using hostgator.

It is a dedicated box elsewhere. Since we are in root there is not prosper202 directory to set permission but file is set to 777.

The file is called - 202-config.php

Using filezilla and generally have no problem with it.

error - goes straight - Error establishing a database connection.

I sure it is something small, but the database info is correct.

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 4437

Post Posted: Apr 30th, 2008 at 9:32am Post subject: Re: INstall Error Reply with quote

profezor wrote:
No, I am not using hostgator.

It is a dedicated box elsewhere. Since we are in root there is not prosper202 directory to set permission but file is set to 777.

The file is called - 202-config.php

Using filezilla and generally have no problem with it.

error - goes straight - Error establishing a database connection.

I sure it is something small, but the database info is correct.

Well it sounds like the file is named correctly, and is being found. And now prosper202 is trying to connect off that 202-config.php file. Do you have the latest source code for this? The 202-config.php file is un-encrypted correct?

If it is still erroring, we can split test it really quick try installing WordPress to see if u can get it to work, it has the same type of installation you'll notice, and if that works. We'll know its prosper202, if it also errors with database connection, we'll know its something related to the MySQl whether it be a firewall blocking incoming connections from your domain or whatever it is.

Back to top
knector
Website Twitter Skype


Joined: Jun 10th, 2009
Posts: 6

Post Posted: Jul 15th, 2009 at 11:03pm Post subject: Re: INstall Error Reply with quote

Hi

I get this error when trying to login/install, both if I create the 202-config.php or let it make it for me, I have come to the username, password and time setting site with the last solution, but just as I pressed ok I just got a whole page full of written lines/errors.

Then I tried to write http://mydomain.com/202-account/account.php I then come to login but it says my password was wrong and when I will reset it, it says that user don't exist, I tried to open some other pages but they just did the same thing.

But if we can take it from the start from here where I make my own file, I hope you know what it is. Thanks.

Table 'knector_prosper202.202_delayed_sqls' doesn't exist

SELECT delayed_sql FROM 202_delayed_sqls WHERE delayed_time <=1247723645

This is the error I get just after installation.

The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

CREATE TABLE IF NOT EXISTS `202_clicks` ( `click_id` bigint(20) unsigned NOT NULL, `user_id` mediumint(8) unsigned NOT NULL, `aff_campaign_id` mediumint(8) unsigned NOT NULL, `landing_page_id` mediumint(8) unsigned NOT NULL, `ppc_account_id` mediumint(8) unsigned NOT NULL, `click_cpc` decimal(7,5) NOT NULL, `click_payout` decimal(6,2) NOT NULL, `click_lead` tinyint(1) NOT NULL default '0', `click_filtered` tinyint(1) NOT NULL default '0', `click_alp` tinyint(1) NOT NULL default '0', `click_time` int(10) unsigned NOT NULL, KEY `aff_campaign_id` (`aff_campaign_id`), KEY `ppc_account_id` (`ppc_account_id`), KEY `click_lead` (`click_lead`), KEY `click_filtered` (`click_filtered`), KEY `click_id` (`click_id`), KEY `overview_index` (`user_id`,`click_filtered`,`aff_campaign_id`,`ppc_account_id`), KEY `user_id` (`user_id`,`click_lead`), KEY `click_alp` (`click_alp`), KEY `landing_page_id` (`landing_page_id`), KEY `overview_index2` (`user_id`,`click_filtered`,`landing_page_id`,`aff_campaign_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (click_time) (PARTITION p0 VALUES LESS THAN (1194159600) ENGINE = MyISAM, PARTITION p1 VALUES LESS THAN (1195369200) ENGINE = MyISAM, PARTITION p2 VALUES LESS THAN (1196578800) ENGINE = MyISAM, PARTITION p3 VALUES LESS THAN (1197788400) ENGINE = MyISAM, PARTITION p4 VALUES LESS THAN (1198998000) ENGINE = MyISAM, PARTITION p5 VALUES LESS THAN (1200207600) ENGINE = MyISAM, PARTITION p6 VALUES LESS THAN (1201417200) ENGINE = MyISAM, PARTITION p7 VALUES LESS THAN (1202626800) ENGINE = MyISAM, PARTITION p8 VALUES LESS THAN (1203836400) ENGINE = MyISAM, PARTITION p9 VALUES LESS THAN (1205046000) ENGINE = MyISAM, PARTITION p10 VALUES LESS THAN (1206255600) ENGINE = MyISAM, PARTITION p11 VALUES LESS THAN (1207465200) ENGINE = MyISAM, PARTITION p12 VALUES LESS THAN (1208674800) ENGINE = MyISAM, PARTITION p13 VALUES LESS THAN (1209884400) ENGINE = MyISAM, PARTITION p14 VALUES LESS THAN (1211094000) ENGINE = MyISAM, PARTITION p15 VALUES LESS THAN (1212303600) ENGINE = MyISAM, PARTITION p16 VALUES LESS THAN (1213513200) ENGINE = MyISAM, PARTITION p17 VALUES LESS THAN (1214722800) ENGINE = MyISAM, PARTITION p18 VALUES LESS THAN (1215932400) ENGINE = MyISAM, PARTITION p19 VALUES LESS THAN (1217142000) ENGINE = MyISAM, PARTITION p20 VALUES LESS THAN (1218351600) ENGINE = MyISAM, PARTITION p21 VALUES LESS THAN (1219561200) ENGINE = MyISAM, PARTITION p22 VALUES LESS THAN (1220770800) ENGINE = MyISAM, PARTITION p23 VALUES LESS THAN (1221980400) ENGINE = MyISAM, PARTITION p24 VALUES LESS THAN (1223190000) ENGINE = MyISAM, PARTITION p25 VALUES LESS THAN (1224399600) ENGINE = MyISAM, PARTITION p26 VALUES LESS THAN (1225609200) ENGINE = MyISAM, PARTITION p27 VALUES LESS THAN (1226818800) ENGINE = MyISAM, PARTITION p28 VALUES LESS THAN (1228028400) ENGINE = MyISAM, PARTITION p29 VALUES LESS THAN (1229238000) ENGINE = MyISAM, PARTITION p30 VALUES LESS THAN (1230447600) ENGINE = MyISAM, PARTITION p31 VALUES LESS THAN (1231657200) ENGINE = MyISAM, PARTITION p32 VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */;

PS. I use hostgator

Back to top
knector
Website Twitter Skype


Joined: Jun 10th, 2009
Posts: 6

Post Posted: Jul 16th, 2009 at 12:52am Post subject: Re: INstall Error Reply with quote

I found the solution, it could not be installed on HostGator because their msql don't support tables, but I found this site http://blog.bluelayermedia.com/installing-prosper202-hostgator.html which had a "functions-install.php" which should overwrite the original, and when had done that it just worked right away.

But thanks anyway and thanks for a great software.

Back to top
T202Aaron
Website Twitter AIM


Joined: Sep 9th, 2008
Posts: 986

Post Posted: Jul 16th, 2009 at 11:00am Post subject: Re: INstall Error Reply with quote

You're welcome and take care

Back to top
organiser1
Website


Joined: Aug 23rd, 2009
Posts: 2

Post Posted: Sep 21st, 2009 at 9:04am Post subject: Re: INstall Error Reply with quote

AHHHH!! im pulling my hair out, I get the login page for prosper on my domain and as soon as i put in my login details i get this error!!! PLEASE HELP>

Table 'organise_prosper202.202_delayed_sqls' doesn't exist

SELECT delayed_sql FROM 202_delayed_sqls WHERE delayed_time <=1253548993

Back to top
GrahamHunt


Joined: Feb 19th, 2010
Posts: 3

Post Posted: Mar 2nd, 2010 at 9:54pm Post subject: Re: INstall Error Reply with quote

I have the same problem as above. If anyone have the solution please help me and let me know how to resolve this issue.

Back to top
jerome


Joined: Mar 6th, 2009
Posts: 1

Post Posted: Mar 6th, 2010 at 4:01am Post subject: Re: INstall Error Reply with quote

Hi,

If your with Hostgator they have a very simple solution.

http://support.hostgator.com/articles/getting-started/general-help/install-prosper202

Install Prosper202

You may run into a problem installing Prosper202 on a HostGator shared server.

http://support.hostgator.com/articles/getting-started/general-help/install-prosper202

Solution:

1. Locate the functions-install.php file (inside the 202-config folder) and delete it.

2. Upload this file and rename it to functions-install.php

They give you a file to download called functions_install.txt

Back to top
GrahamHunt


Joined: Feb 19th, 2010
Posts: 3

Post Posted: Mar 8th, 2010 at 12:08am Post subject: Re: INstall Error Reply with quote

We installed prosper on our hostgator server. But when we tried to login into the login page it shows a database error as

Table 'grahunt_hfsis.202_delayed_sqls' doesn't exist

SELECT delayed_sql FROM 202_delayed_sqls WHERE delayed_time <=1267595898

The URL is trackinghsis.devanio.com

Please help to resolve this issue.

Back to top
t202nate


Joined: Mar 3rd, 2010
Posts: 247

Post Posted: Mar 8th, 2010 at 2:26pm Post subject: Re: INstall Error Reply with quote

GrahamHunt,

So we can better assist you, have you tried the solutions written by jerome.

----"

Hi,

If your with Hostgator they have a very simple solution.

http://support.hostgator.com/articles/getting-started/general-help/install-prosper202

Install Prosper202

You may run into a problem installing Prosper202 on a HostGator shared server.

http://support.hostgator.com/articles/getting-started/general-help/install-prosper202

Solution:

1. Locate the functions-install.php file (inside the 202-config folder) and delete it.

2. Upload this file and rename it to functions-install.php

They give you a file to download called functions_install.txt

"----

Back to top
Post new topic Reply to topic Page 1 of 1