customers cant login??

[buydemon]

Hmm... i dont understand any of the following. The problem is that when a customer tries to login they recieve the following error:

 

1054 - Unknown column 'member_level' in 'field list'

 

select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, member_level from customers where customers_email_address = '[email protected]'

 

[TEP STOP]

 

Im not sure how to sort this out.

Any help appreciated, thanks in advance.

Carl

[♥Monika in Germany]

Hmm... i dont understand any of the following. The problem is that when a customer tries to login they recieve the following error:

Im not sure how to sort this out.

Any help appreciated, thanks in advance.

Carl

Looks like you have installed a contribution for member level and haven't run the database file that came with it. Carefully read the install file and correct this in your database.

[buydemon]

Looks like you have installed a contribution for member level and haven't run the database file that came with it. Carefully read the install file and correct this in your database.

 

thanks for the answer. I havnt installed any contributions and it was preinstalled with my host. I will reinstall again, thanks.

[buydemon]

hm.... still the same problem. I have reinstalled, checked all files etc. Does anyone know which contribution may becausing this problem. Thanks, Carl

[♥Monika in Germany]

hm.... still the same problem. I have reinstalled, checked all files etc. Does anyone know which contribution may becausing this problem. Thanks, Carl

none that I know ... but there are 3000+.

 

Add a column member_level to your customers table and see what happens

[buydemon]

i guess i do this through phpmyadmin??

 

are there any topics that will help me do this, cant find any with search. Thanks vary much,

Carl

[buydemon]

i guess i do this through phpmyadmin??

 

are there any topics that will help me do this, cant find any with search. Thanks vary much,

Carl

 

ok im slowley getting there lol.

 

i ran the follwing sql query:

 

ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL;

 

i them created a php code from this:

 

$sql = 'ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT \'0\' NOT NULL;';

 

however, since i got this far, im not sure what to do with this code. Any help appreciated.

Thanks,

Carl

[♥Monika in Germany]

ok im slowley getting there lol.

 

i ran the follwing sql query:

i them created a php code from this:

however, since i got this far, im not sure what to do with this code. Any help appreciated.

Thanks,

Carl

there is no need to create a php after adding the column. Did you try to login as a customer?

[buydemon]

there is no need to create a php after adding the column. Did you try to login as a customer?

 

no customers still cant login.... im now baffled. the query succeded. i guess there must be another problem. any help.

[♥Monika in Germany]

post login.php

[buydemon]

<?php

/*

$Id: login.php,v 1.80 2003/06/05 23:28:24 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)

if ($session_started == false) {

tep_redirect(tep_href_link(FILENAME_COOKIE_USAGE));

}

 

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

 

$error = false;

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process')) {

$email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);

$password = tep_db_prepare_input($HTTP_POST_VARS['password']);

 

// Check if email exists

$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, member_level from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");

if (!tep_db_num_rows($check_customer_query)) {

$error = true;

} else {

$check_customer = tep_db_fetch_array($check_customer_query);

// Check that password is good

if (!tep_validate_password($password, $check_customer['customers_password'])) {

$error = true;

} else {

 

if ($check_customer['member_level'] == 0 ) {

$HTTP_GET_VARS['login'] = 'invalid';

$messageStack->add('login', TEXT_NOT_APPROVED);

} else {

 

 

if (SESSION_RECREATE == 'True') {

tep_session_recreate();

}

 

$check_country_query = tep_db_query("select entry_country_id, entry_zone_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$check_customer['customers_id'] . "' and address_book_id = '" . (int)$check_customer['customers_default_address_id'] . "'");

$check_country = tep_db_fetch_array($check_country_query);

 

$customer_id = $check_customer['customers_id'];

$customer_default_address_id = $check_customer['customers_default_address_id'];

$customer_first_name = $check_customer['customers_firstname'];

$customer_country_id = $check_country['entry_country_id'];

$customer_zone_id = $check_country['entry_zone_id'];

tep_session_register('customer_id');

tep_session_register('customer_default_address_id');

tep_session_register('customer_first_name');

tep_session_register('customer_country_id');

tep_session_register('customer_zone_id');

 

tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 where customers_info_id = '" . (int)$customer_id . "'");

 

// restore cart contents

$cart->restore_contents();

 

if (sizeof($navigation->snapshot) > 0) {

$origin_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);

$navigation->clear_snapshot();

tep_redirect($origin_href);

} else {

tep_redirect(tep_href_link(FILENAME_DEFAULT));

}

}

}

}

}

 

if ($error == true) {

$messageStack->add('login', TEXT_LOGIN_ERROR);

}

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_LOGIN, '', 'SSL'));

?>

<!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>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript"><!--

function session_win() {

window.open("<?php echo tep_href_link(FILENAME_INFO_SHOPPING_CART); ?>","info_shopping_cart","height=460,width=430,toolbar=no,statusbar=no,scrollbars=yes").focus();

}

//--></script>

</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="100%" cellspacing="0" cellpadding="0">

<tr>

<!-- body_text //-->

<td width="100%" valign="top"><?php echo tep_draw_form('login', tep_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

if ($messageStack->size('login') > 0) {

?>

<tr>

<td><?php echo $messageStack->output('login'); ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

}

 

if ($cart->count_contents() > 0) {

?>

<tr>

<td class="smallText"><?php echo TEXT_VISITORS_CART; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

}

?>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main" width="50%" valign="top"><b><?php echo HEADING_NEW_CUSTOMER; ?></b></td>

<td class="main" width="50%" valign="top"><b><?php echo HEADING_RETURNING_CUSTOMER; ?></b></td>

</tr>

<tr>

<td width="50%" height="100%" valign="top"><table border="0" width="100%" height="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" height="100%" cellspacing="0" cellpadding="2">

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main" valign="top"><?php echo TEXT_NEW_CUSTOMER . '<br><br>' . TEXT_NEW_CUSTOMER_INTRODUCTION; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<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_CREATE_ACCOUNT, '', 'SSL') . '">' . 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>

</table></td>

<td width="50%" height="100%" valign="top"><table border="0" width="100%" height="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" height="100%" cellspacing="0" cellpadding="2">

<tr>

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main" colspan="2"><?php echo TEXT_RETURNING_CUSTOMER; ?></td>

</tr>

<tr>

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>

<td class="main"><?php echo tep_draw_input_field('email_address'); ?></td>

</tr>

<tr>

<td class="main"><b><?php echo ENTRY_PASSWORD; ?></b></td>

<td class="main"><?php echo tep_draw_password_field('password'); ?></td>

</tr>

<tr>

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="smallText" colspan="2"><?php echo '<a href="' . tep_href_link(FILENAME_PASSWORD_FORGOTTEN, '', 'SSL') . '">' . TEXT_PASSWORD_FORGOTTEN . '</a>'; ?></td>

</tr>

<tr>

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td colspan="2"><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_login.gif', IMAGE_BUTTON_LOGIN); ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table></form></td>

<!-- body_text_eof //-->

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

thanks

[♥Monika in Germany]

Hi,

 

the file looks for a member level of > 0 ... so either remove that column in phpmyadmin and recreate with a default vaklue of 1 or PM me your admin info and I'll have a look around to see what contribs you have messing this up.

[buydemon]

Hi,

 

the file looks for a member level of > 0 ... so either remove that column in phpmyadmin and recreate with a default vaklue of 1 or PM me your admin info and I'll have a look around to see what contribs you have messing this up.

 

thanks very much. ill have a try, if i cant do it ill pm you,

thanks

[buydemon]

ok ive had a look in phpmyadmin. i cant find the file to remove the column in to recreate a new one??

 

i ran a search but i got the following error:

 

#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 'select customers_id , customers_

LIMIT 0, 30' at line 1

[buydemon]

LIMIT 0, 30' at line 1

 

this looks like the problem to me and correlates to what you said above.... i think lol

 

?????

[♥Monika in Germany]

no ... in the structure view of the custumers table, there is each column for you to delete. red X

[buydemon]

ok sent u details, thx

[♥Monika in Germany]

ok sent u details, thx

Carl, all fixed :-)

 

here is the solution in case someone else gets a mess like this:

 

Carl uses a template. It looks tome that the template was not created for osC as it's the default version ... but for a version that uses this contrib http://www.oscommerce.com/community/contri...customer+access

... but only in the login file ;-), not in the database etc etc

 

I removed the parts that were non-standard and was able to log in.

[buydemon]

THANKYOU VERY MUCH!!!!!!!!!!!!!!

 

greatly appreciated!

 

.... only if everyone was like you :D :D :D :D :D :D

[i2yan]

Carl, all fixed :-)

 

here is the solution in case someone else gets a mess like this:

 

Carl uses a template. It looks tome that the template was not created for osC as it's the default version ... but for a version that uses this contrib http://www.oscommerce.com/community/contri...customer+access

... but only in the login file ;-), not in the database etc etc

 

I removed the parts that were non-standard and was able to log in.

 

 

im a bit confused here, i downloaded the contrib file because im getting the exact same error as buydemon was. do i just make the changes mentioned in the contrib to the login files and nothing else?

[najis]

im a bit confused here, i downloaded the contrib file because im getting the exact same error as buydemon was. do i just make the changes mentioned in the contrib to the login files and nothing else?

 

I have this solved..

just try download member approval version 1.5.1 from http://www.oscommerce.com/community/contri...customer+access

and follow the instruction from the read me files.

everything should be ok.

 

Thanks

[aboyz]

Monika,

 

Can you tell me which file to remove in the login.php file instead of installing the mods.

 

thanks

[♥Monika in Germany]

Hi David,

 

find this

}

}

}

}

}

 

if ($error == true) {

$messageStack->add('login', TEXT_LOGIN_ERROR);

}

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_LOGIN, '',

'SSL'));

?>

 

 

remove the bolded bracket so you only have 3, not 4

 

then find this

if ($check_customer['member_level'] == 0 ) {

$HTTP_GET_VARS['login'] = 'invalid';

$messageStack->add('login', TEXT_NOT_APPROVED);

} else {

 

and remove completely