114 replies to this topic

[shadow007]

This contribution is great!
I tested it and all worked well.
But when I delete a customer in osCommerce, I find that the customer isn't be removed in Phplist.
Any reason for this?

[higgalls]

shadow007, on Sep 7 2006, 11:27 AM, said:

This contribution is great!
I tested it and all worked well.
But when I delete a customer in osCommerce, I find that the customer isn't be removed in Phplist.
Any reason for this?

Maybe that function wasn't coded. If you can code it and put it in the contrib area then that would be great.

Cheers,
Chris

[higgalls]

stonebridgecomputing, on Jan 29 2006, 04:25 PM, said:

Hey Everyone,

Needing your help with finishing the phplist integration to the contact_us.php page.
Basically, it is not adding the email address to the phplist database.

Here is the code:

<?php
/*
  $Id: contact_us.php,v 1.42 2003/06/12 12:17:07 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce  Released under the GNU General Public License

Modified for VN2 Free Skin E by Kevin jeffery - www.vn2designs.com
*/

  require('includes/application_top.php');

  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CONTACT_US);

  $error = false;
  if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'send')) {
	$name = tep_db_prepare_input($HTTP_POST_VARS['name']);
	$email_address = tep_db_prepare_input($HTTP_POST_VARS['email']);
	$enquiry = tep_db_prepare_input($HTTP_POST_VARS['enquiry']);
	if (isset($HTTP_POST_VARS['newsletter'])) {
	  $newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
	} else {
	  $newsletter = false;
	}
	if (tep_validate_email($email_address)) {
	  tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_SUBJECT, $enquiry, $name, $email_address);
	  if(SEND_CONTACT_US_RESPONSE=='true')
	  tep_mail($name, $email_address, CONTACT_US_RESPONSE_EMAIL_SUBJECT, CONTACT_US_RESPONSE_EMAIL_TEXT."\n\n-------------------------Your Message:\n".$enquiry, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
	  tep_redirect(tep_href_link(FILENAME_CONTACT_US, 'action=success'));
	} else {
	  $error = true;

	  $messageStack->add('contact', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
	}
}

 // Begin PHPlist Newsletter add-on
	   require(DIR_WS_INCLUDES . '/phplist_define.php'); //get the phplist specifics
	   //get user specifics from PHPlist
	   $existing_email_query = tep_db_query("select id, email, foreignkey from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user where email = '" . $email_address . "'"); //check for existing by email address
	   $history_systeminfo_text = "\nHTTP_USER_AGENT = " . $_SERVER["HTTP_USER_AGENT"] ."\nHTTP_REFERER = " . $_SERVER["HTTP_REFERER"] . "\nREMOTE_ADDR = " . $_SERVER["REMOTE_ADDR"] . "";
	   $history_detail_text = "";
	   //subscribe logic
	   if ($newsletter) {
		 if (tep_db_num_rows($existing_email_query) < 1) { //no existing user by email address found (therefore a new user - no id or email found)
		   $id = md5(uniqid(mt_rand())); //generate unique id and add new user to database
		   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user (email, confirmed, subscribepage, entered, modified, disabled, uniqid, htmlemail, foreignkey) values ('" . $email_address . "', 1, " . PHPLIST_SPAGE . ", now(), now(), 0, '" . $id . "', " . PHPLIST_HTMLEMAIL . ", " . $customer_id . ")"); //insert the new user into phplist
		   $user_query=tep_db_query("select id from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user where email = '" . $email_address . "'"); //get the new user's phplist id
		   $user = tep_db_fetch_array($user_query);
		   //tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_attribute (attributeid, userid, value) values (" . PHPLIST_FIRSTNAME . ", " . $user['id'] . ", '" . $firstname . "')"); //add the users firstname to the attributes table
		   //tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_attribute (attributeid, userid, value) values (" . PHPLIST_LASTNAME . ", " . $user['id'] . ", '" . $lastname . "')"); //add the users lastname to the attributes table
		   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser (userid, listid, entered) values (" . $user['id'] . ", " . PHPLIST_LISTNO . ", now())"); //subscribe the new user to the correct list
		   //generating history
		   $history_detail_text .= "\nSubscribepage = " . PHPLIST_SPAGE . "\nforeign key = " . $customer_id . "\n";
		   //$attribute_name_query = tep_db_query("select name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_attribute where id = " . PHPLIST_FIRSTNAME . "");
		   //$attribute_name = tep_db_fetch_array($attribute_name_query);
		   //$history_detail_text .= "" . $attribute_name[name] . " = " . $firstname . "\n";
		   //$attribute_name_query = tep_db_query("select name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_attribute where id = " . PHPLIST_LASTNAME . "");
		   //$attribute_name = tep_db_fetch_array($attribute_name_query);
		   //$history_detail_text .= "" . $attribute_name[name] . " = " . $lastname . "\n";
		   $list_name_query = tep_db_query("select name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "list where id = " . PHPLIST_LISTNO . "");
		   $list_name = tep_db_fetch_array($list_name_query);
		   $history_detail_text .= "\nList subscriptions:\n" . $list_name['name'] . "";
		   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_history (userid, ip, date, summary, detail, systeminfo) values (" . $user['id'] . ", '" . $_SERVER["REMOTE_ADDR"] . "', '" . date('Y-m-d H:i:s') . "', 'Update through osC', '" . $history_detail_text . "', '" . $history_systeminfo_text . "')"); //create history post
		 }
		 else { //subscribe the existing user if disabled and add foreignkey match to customer_id
		   $existing_email = tep_db_fetch_array($existing_email_query); //existing user by email found
		   tep_db_query("update " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user set disabled = 0, confirmed = 1, foreignkey = " . $customer_id . " where id = " . $existing_email['id'] . "");
		   $history_detail_text .= "foreign key = " . $customer_id . "\nchanged from ";
		   //check to see if they already are subscribed to the correct list
		   $list_query = tep_db_query("select * from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser where userid = " . $existing_email['id'] . " and listid = " . PHPLIST_LISTNO . "");
		   if ($list=tep_db_num_rows($list_query) < 1) { //no existing subscription to the newsletter found
			 //generating history, previous subscriptions
			 $history_detail_text .= "\n\nList subscriptions:\n";
			 $existing_subscription_query = tep_db_query("select li.name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "list li, " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser lu where li.id = lu.listid and lu.userid = " . $existing_email['id'] . "");
			 if (tep_db_num_rows($existing_subscription_query) < 1) {
			   $history_detail_text .= "Was subscribed to: \n";
			 } else {
			   while($existing_subscription = tep_db_fetch_array($existing_subscription_query)){
				 $history_detail_text .= "Was subscribed to: " . $existing_subscription[name] . "\n";
			   }
			 }
			 tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser (userid, listid, entered) values (" . $existing_email['id'] . ", " . PHPLIST_LISTNO . ", now())"); //subscribe the new user to the correct list
			 //generating history, current (updated) subscriptions
			 $updated_subscription_query = tep_db_query("select li.name from " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "list li, " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "listuser lu where li.id = lu.listid and lu.userid = " . $existing_email['id'] . "");
			 while ($updated_subscription = tep_db_fetch_array($updated_subscription_query)) {
			   $history_detail_text .= "Is now subscribed to: " . $updated_subscription[name] . "\n";
			 }
		   }
		   tep_db_query("insert into " . PHPLIST_DB . "" . PHPLIST_TABLE_PREFIX . "user_user_history (userid, ip, date, summary, detail, systeminfo) values (" . $existing_email['id'] . ", '" . $_SERVER["REMOTE_ADDR"] . "', '" . date('Y-m-d H:i:s') . "', 'Update through osC', '" . $history_detail_text . "', '" . $history_systeminfo_text . "')"); //create history post
		 }
	   }
 // End PHPlist Newsletter add-on
  $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CONTACT_US));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<META NAME="publisher" CONTENT="HostingosCommerce.com">
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="760" align="center" cellspacing="0" cellpadding="0" background="images/mainbg.jpg">
  <tr>
	<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
	</table></td>
<!-- body_text //-->
	<td width="100%" valign="top"><?php echo tep_draw_form('contact_us', tep_href_link(FILENAME_CONTACT_US, 'action=send')); ?><table border="0" width="440" align="center" cellspacing="0" cellpadding="0">
	  <tr>
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
			<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_contact_us.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
<?php
  if ($messageStack->size('contact') > 0) {
?>
	  <tr>
		<td><?php echo $messageStack->output('contact'); ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
<?php
  }

  if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'success')) {
?>
	  <tr>
		<td class="main" align="center"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_man_on_board.gif', HEADING_TITLE, '0', '0', 'align="left"') . TEXT_SUCCESS; ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
		  <tr class="infoBoxContents">
			<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
			  <tr>
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
				<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			  </tr>
			</table></td>
		  </tr>
		</table></td>
	  </tr>
<?php
  } else {
?>
	  <tr>
		<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
		  <tr class="infoBoxContents">
			<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
				<td class="main">If you have any enquries, please feel free to email us at <a href="mailto:sales@stonebridgecomputing.com.au">sales@stonebridgecomputing.com.au</a>, or feel free to use the following form.<br><br></td>
			  </tr>
			  <tr>
				<td class="main"><?php echo ENTRY_NAME; ?></td>
			  </tr>
			  <tr>
				<td class="main"><?php echo tep_draw_input_field('name'); ?></td>
			  </tr>
			  <tr>
				<td class="main"><?php echo ENTRY_EMAIL; ?></td>
			  </tr>
			  <tr>
				<td class="main"><?php echo tep_draw_input_field('email'); ?></td>
			  </tr>
<tr>
				<td class="main">Subscribe to Newsletter?
				<?php echo tep_draw_checkbox_field('newsletter', '1',checked) . '&nbsp;' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td>
</tr>
			  <tr>
				<td class="main"><?php echo ENTRY_ENQUIRY; ?></td>
			  </tr>
			  <tr>
				<td><?php echo tep_draw_textarea_field('enquiry', 'soft', 50, 15); ?></td>
			  </tr>
			</table></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
		  <tr class="infoBoxContents">
			<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
			  <tr>
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
				<td align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>
				<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			  </tr>
			</table></td>
		  </tr>
		</table></td>
	  </tr>
<?php
  }
?>
	</table></form></td>
<!-- body_text_eof //-->
	<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
	</table></td>
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Has anyone got any idea?
I want to get this going asap. It has been ages with it not working from the contact us page.

Cheers,
Chris

[beano]

blanktape, on Jun 30 2006, 05:08 PM, said:

1064 - 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 '-_phplist.phplist_user_user where email = 'me@jamesyang.info'' at line 1

select id, email, foreignkey from rocketz_net_-_phplist.phplist_user_user where email = 'me@jamesyang.info'
Hmm...syntax error....

can someone suggest me where to look for??

james

I've got the exact same problem with my install. Did you ever get an answer or figure out how to
fix this error?

[gregy]

i have another question. If i understood you well, only customers may enter mailing list. What about visitors.

I.e. I don't want to buy anything or register. Then i suppose you don't want me on your mailing list?

[gregy]

and another question (dunno why i can't edit previous post)

i'm trying to add subscription code (which is working in separate file) into infobox

The code is

<!-- mailing //-->
		  <tr>
			<td>
<?php
  $info_box_contents = array();
  $info_box_contents[] = array('text' => BOX_HEADING_MAILING);

  new infoBoxHeading($info_box_contents, false, false, false, $column_location);

  $info_box_contents = array();
  $info_box_contents[] = array('text'  => '<script language="Javascript" type="text/javascript">
var fieldstocheck = new Array();
	fieldnames = new Array();
function checkform() {
  for (i=0;i<fieldstocheck.length;i++) {
	if (eval("document.subscribeform.elements['"+fieldstocheck[i]+"'].value") == "") {
	  alert("Prosimo vnesite  "+fieldnames[i]);
	  eval("document.subscribeform.elements['"+fieldstocheck[i]+"'].focus()");
	  return false;
	}
  }

  return true;
}

function addFieldToCheck(value,name) {
  fieldstocheck[fieldstocheck.length] = value;
  fieldnames[fieldnames.length] = name;
}

function compareEmail()
{
  return (document.subscribeform.elements["email"].value == document.subscribeform.elements["emailconfirm"].value);
}
</script>
<form method="post" action="http://www.domain.com/mailing/lists/?p=subscribe" name="subscribeform"><table border="0">
  <tbody><tr><td colspan="2"><div class="required">Elektronski naslov</div><input name="email" value="" size="20" type="text">
  <script language="Javascript" type="text/javascript">addFieldToCheck("email","Elektronski naslov");</script></td>
	  </tr><tr><td colspan="2">
	  <div class="required">Ime in Priimek</div>
			<input name="attribute1" class="attributeinput" size="20" value="" type="text"><script language="Javascript" type="text/javascript">addFieldToCheck("attribute1","Ime in Priimek");</script></td></tr>

	<tr><td>
		<span class="attributename">Format<br>
		sporočila:</span><br>
		<span class="attributeinput"><input name="htmlemail" value="0" type="radio"></span>
		<span class="attributename">Tekst<br>
		</span><span class="attributeinput"><input name="htmlemail" value="1" checked="checked" type="radio"></span>

		<span class="attributename">HTML</span></td><td>
		<input name="list[7]" value="signup" type="hidden"><input name="listname[7]" value="Vstopnice.com" type="hidden"><input name="subscribe" value="Prijava" onclick="return checkform();" type="submit"></p>
	</form></td></tr>
</tbody></table><a href="http://www.domain.com/mailing/lists/?p=unsubscribe&amp;id=3">Odjavi</a>');

 

  new infoBox($info_box_contents, $column_location);
?>
			</td>
		  </tr>


<!-- mailing_eof //-->

but this code stops page from loading when comes to this infobox?

any help please?

[pilkaroo]

barryjacq2, on Aug 21 2006, 06:06 PM, said:

Thanks Chris for the suggestion. For the time being I created the lastname attribute in PHPlist and set it to not-required. That seems to be a work around that avoids having to change the code.
Barry

Interesting workaround. Worked for me, except I had to also do the same for the firstname attribute.

I'm still interested in finding out why this error occurred.

Christine
http://www.epiccycling.com/

[JeremyToaster]

Hey this worked great!
I had to work with getting this part set up just right...

define('PHPLIST_DB', 'mydatabase_phplist.'); //the name of the phplist database if same as osC, leave blank
define('PHPLIST_TABLE_PREFIX', 'phplist_'); //if a table prefix is used give it here (if none, leave blank)

I just tried all the different ways, with and without the _ and with and without the . and with and without the PREFIX all together.

Finally this final result up top worked out. Also had to remember to do it in BOTH the ADMIN and the NORMAL section.

Also, the way I have my databases set up in phpMyAdmin are like so...

MYSITE
_phplist
_store
_shows
_forum

So each database for different systems are sub groups under my main website

MYSITE_phplist
MYSITE_store

So they are separate databases but fall under the same group.



What my question is, can you either A) export the list of emails in OsCommerce or can I send all the emails to phpList from OsCommerce using this?

Also, is this supposed to change the "Send Email" and "Newsletter" sections in the OsCommerce Admin section into phpList functions?

Thanks again this is a wonderful start to my site wide conversion process!

j

[dragon5]

Hello. PHPList was installed via Fantastico on my Lunarpages server (in it's own dir.). It trashed the admin side of my store. I can now only get to the /catalog/admin page, but i get 'server not found' when attempting to access any of the selections on the admin page. (customers, tools, etc....) It also changed my admin access password to the password i created when installing PHPList! My store is live and i now have to go into the db to get customer data for EVERY order. Any suggestions/help would be MOST appreciated.
Thanks
Tom

[higgalls]

dragon5, on Nov 28 2006, 08:04 AM, said:

Hello. PHPList was installed via Fantastico on my Lunarpages server (in it's own dir.). It trashed the admin side of my store. I can now only get to the /catalog/admin page, but i get 'server not found' when attempting to access any of the selections on the admin page. (customers, tools, etc....) It also changed my admin access password to the password i created when installing PHPList! My store is live and i now have to go into the db to get customer data for EVERY order. Any suggestions/help would be MOST appreciated.
Thanks
Tom

Hi,

Re-upload the Admin section from your catalog, either through a backup, or by downloading all of OsCommerce and then getting the Admin section from that (preferably from your own backup though).

Regards,
Chris

[dragon5]

Thanks Chris, but what would that do for me? It would seem, that by the way this is screwing up, that it may have something to with .htpasswrd or httpd.conf? It doesn't appear that the admin side has been corrupted, just the access to it. Ex. 'can't find the server at www.mydomain.comdir_ws_admincategories.php.' admin/categories.php is definitely still available on the server. I'm sure all this goes deeper than my limited understanding, but none of the admin files appear to be corrupted, and thay are all still in the same place thay have been for 4 years. I just can no longer access them. Sure is a pain in the a** to go into the db for customer info for every order!
Thanks again.
Tom

[dragon5]

And, since the install of PHPList arbitrarily changed my access password, the access password that is encrypted in configure.php is no longer valid. Since I can't get into the config section of admin, I can't change the password to the new one. Make any sense at all????

Also, I noted that when accessing catalog/admin, the popup password entry box does pop up and this is where I added the new password to get to the admin panel. When I attempt to access any of the apps, I do NOT get the password entry box that I used to, just the 'server not found' error msg.
Tom

[higgalls]

dragon5, on Nov 28 2006, 09:29 AM, said:

And, since the install of PHPList arbitrarily changed my access password, the access password that is encrypted in configure.php is no longer valid. Since I can't get into the config section of admin, I can't change the password to the new one. Make any sense at all????

Also, I noted that when accessing catalog/admin, the popup password entry box does pop up and this is where I added the new password to get to the admin panel. When I attempt to access any of the apps, I do NOT get the password entry box that I used to, just the 'server not found' error msg.
Tom

There are a few things that aren't making sense to me.

Firstly, is the password for your admin stored in configure.php or in the database?
Is the password for the Admin using an oscommerce contrib, or is it simply a password protected directory? If it is a password protected directory then you simply need to log into your cpanel (if you have one) and reset the password.

Secondly, PHPList should NOT have changed your password at all as it should have installed itself completely separate from OsCommerce. So I don't know why it wouldn't work anymore.

Regards,
Chris

[dragon5]

Thanks Chris. Even the sys administrators at Lunarpages can't seem to figure this out. I realize that PHPList should not have messed with my passwords, but somehow it did. I even installed to a separate directory just to prevent this type of thing happening!

When I go into my cpanel, admin is password protected and I can change the password but I don't want to mess with the Lunarpages guys until they are done.

No, I am not using an osc contrib for passwords.

The encrypted password in the 'define('DB_SERVER_PASSWORD',' statement in admin/includes/configure.php is still what it has always been. Could this be a conflict? If so, how would this be corrected.

It's been 4 years since I setup my store, so some things I did initially, are hard to remember (getting OLD!)

Thanks for your continued efforts.
Tom

[higgalls]

dragon5, on Nov 28 2006, 12:52 PM, said:

Thanks Chris. Even the sys administrators at Lunarpages can't seem to figure this out. I realize that PHPList should not have messed with my passwords, but somehow it did. I even installed to a separate directory just to prevent this type of thing happening!

When I go into my cpanel, admin is password protected and I can change the password but I don't want to mess with the Lunarpages guys until they are done.

No, I am not using an osc contrib for passwords.

The encrypted password in the 'define('DB_SERVER_PASSWORD',' statement in admin/includes/configure.php is still what it has always been. Could this be a conflict? If so, how would this be corrected.

It's been 4 years since I setup my store, so some things I did initially, are hard to remember (getting OLD!)

Thanks for your continued efforts.
Tom

Hi,

The password in configure.php should just be your normal mysql database password. It shouldn't be encrypted (unless you have installed some sort on password encryption contrib???). It should simply be typed into it.

So when you try to go to your admin area, does it ask you your username and password? When you enter it in, what happens?

Regards,
Chris

[dragon5]

Chris, when I go to admin, it asks for my username and password. I enter the correct data, (which is now a different pw) and it takes me to the admin panel. The problems begin here. When I attempt to access any of the choices on the panel, I get the 'server not found' error.
Tom

[higgalls]

dragon5, on Nov 28 2006, 02:02 PM, said:

Chris, when I go to admin, it asks for my username and password. I enter the correct data, (which is now a different pw) and it takes me to the admin panel. The problems begin here. When I attempt to access any of the choices on the panel, I get the 'server not found' error.
Tom

Ok, now I have more of an idea of what is going on.

Edit your admin configure.php and enter in your actual database password (may be the same password as your cpanel password). Do not enter it in encrypted or anything. Just enter it in as normal, and let me know how you go.

Cheers,
Chris

[dragon5]

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xxxxxxxx2_osc4'@'localhost' (using password: YES) in /home/xxxxxxxxx2/public_html/catalog/admin/includes/functions/database.php on line 19
Unable to connect to database server!

If i use my pw (Not my real data!)
define('DB_SERVER_PASSWORD', '456789'); I get the above error msg.


This lets me into the admin panel, but no farther. (again, not my real data, but this is what it looks like)

define('DB_SERVER_PASSWORD', 'Iwc_5Z4vsB');

also, I do not type Iwc_5Z4vsB as a password for anything.
I have not installed any pw encryption contrib.
Tom

[higgalls]

dragon5, on Nov 28 2006, 02:25 PM, said:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xxxxxxxx2_osc4'@'localhost' (using password: YES) in /home/xxxxxxxxx2/public_html/catalog/admin/includes/functions/database.php on line 19
Unable to connect to database server!

If i use my pw (Not my real data!)
define('DB_SERVER_PASSWORD', '456789'); I get the above error msg.
This lets me into the admin panel, but no farther. (again, not my real data, but this is what it looks like)

define('DB_SERVER_PASSWORD', 'Iwc_5Z4vsB');

also, I do not type Iwc_5Z4vsB as a password for anything.
I have not installed any pw encryption contrib.
Tom

Hi,

Do you want to PM me your cpanel details and database username and password, as well as your shop URL and I will jump in and take a look for you? Surely it cannot be this hard :S

Cheers,
Chris

[dragon5]

Chris, it is late here and I need to get some sleep before work at 6am. Let me sleep on this and get back tomorrow. Again, I appreciate you efforts.
Tom