secure user login problem

[alinojoumi]

hi there
i bought a addon for auto user registeration and when i register a user and goto login page
everything is ok but as soon as i put the user validation form on the same secure page so that i can accept people that they registered themself the page gives me an erro massage saying Table 'forex_sope1.cart_customers' doesn't exist
do you know what the problem could be?
thanks

[lwyau]

I am not the author of this plug-in so I don't know its details.

However, "cart_customers" table is used for returned customers to log-in, one of the secure user login facilities. I assume the plug-in tries to establish login record there in addition to the regular table sec_users, though I'm surprised that the author did not make this an optional deal.

Anyway, I suggest that you create this table to see if its presence fixes the problem. To create this table short of going through the process of setting up your shopping cart, you can go to your cpanel (not sohoadmin) > mysql database > phpmyadmin, select the database used for soho, click on "SQL" and run the following table creation SQL command:


CREATE TABLE `cart_customers` (
`PRIKEY` int(11) NOT NULL auto_increment,
`USERNAME` varchar(100) default NULL,
`PASSWORD` varchar(100) default NULL,
`BILLTO_FIRSTNAME` varchar(100) default NULL,
`BILLTO_LASTNAME` varchar(100) default NULL,
`BILLTO_COMPANY` varchar(100) default NULL,
`BILLTO_ADDR1` varchar(100) default NULL,
`BILLTO_ADDR2` varchar(100) default NULL,
`BILLTO_CITY` varchar(50) default NULL,
`BILLTO_STATE` varchar(50) default NULL,
`BILLTO_COUNTRY` varchar(75) default NULL,
`BILLTO_ZIPCODE` varchar(20) default NULL,
`BILLTO_PHONE` varchar(75) default NULL,
`BILLTO_EMAILADDR` varchar(100) default NULL,
`SHIPTO_FIRSTNAME` varchar(100) default NULL,
`SHIPTO_LASTNAME` varchar(100) default NULL,
`SHIPTO_COMPANY` varchar(100) default NULL,
`SHIPTO_ADDR1` varchar(100) default NULL,
`SHIPTO_ADDR2` varchar(100) default NULL,
`SHIPTO_CITY` varchar(50) default NULL,
`SHIPTO_STATE` varchar(50) default NULL,
`SHIPTO_COUNTRY` varchar(75) default NULL,
`SHIPTO_ZIPCODE` varchar(20) default NULL,
`SHIPTO_PHONE` varchar(75) default NULL,
`FUTURE1` blob,
`FUTURE2` blob,
PRIMARY KEY (`PRIKEY`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

[alinojoumi]

hi again
i did exactly as you asked but it says at the end
Error
SQL query:

CREATE TABLE `cart_customers` (

`PRIKEY` int( 11 ) NOT NULL AUTO_INCREMENT ,
`USERNAME` varchar( 100 ) default NULL ,
`PASSWORD` varchar( 100 ) default NULL ,
`BILLTO_FIRSTNAME` varchar( 100 ) default NULL ,
`BILLTO_LASTNAME` varchar( 100 ) default NULL ,
`BILLTO_COMPANY` varchar( 100 ) default NULL ,
`BILLTO_ADDR1` varchar( 100 ) default NULL ,
`BILLTO_ADDR2` varchar( 100 ) default NULL ,
`BILLTO_CITY` varchar( 50 ) default NULL ,
`BILLTO_STATE` varchar( 50 ) default NULL ,
`BILLTO_COUNTRY` varchar( 75 ) default NULL ,
`BILLTO_ZIPCODE` varchar( 20 ) default NULL ,
`BILLTO_PHONE` varchar( 75 ) default NULL ,
`BILLTO_EMAILADDR` varchar( 100 ) default NULL ,
`SHIPTO_FIRSTNAME` varchar( 100 ) default NULL ,
`SHIPTO_LASTNAME` varchar( 100 ) default NULL ,
`SHIPTO_COMPANY` varchar( 100 ) default NULL ,
`SHIPTO_ADDR1` varchar( 100 ) default NULL ,
`SHIPTO_ADDR2` varchar( 100 ) default NULL ,
`SHIPTO_CITY` varchar( 50 ) default NULL ,
`SHIPTO_STATE` varchar( 50 ) default NULL ,
`SHIPTO_COUNTRY` varchar( 75 ) default NULL ,
`SHIPTO_ZIPCODE` varchar( 20 ) default NULL ,
`SHIPTO_PHONE` varchar( 75 ) default NULL ,
`FUTURE1` blob,
`FUTURE2` blob,
PRIMARY KEY ( `PRIKEY` )
) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT CHARSET = latin1

MySQL said:

#1050 - Table 'cart_customers' already exists

what should i do now
should i just return the addon that i have got

[lwyau]

Well, the table was already there but your error message says "it does not exist"...

Don't know what to tell you at this point...

[alinojoumi]

hi again
i fixed the problem but now if i use the form with validation i have to put the member validation form somewhere behind the secure page on the help file it says i have to use the property link and put the validation form on there but i dont see anywhere to put the validation form so i can accept and reject members.
if i put it in the main page if any member sign up they will see the aceppt or reject page.
any idea on this one?

[lwyau]

Again I don't have this plug-in so I don't know the details.

It seems to me this "validation" form is for you and you only to use. So I'd create a page with a security code (a different one from the one members are assigned to) authorized for you only for this form. This page can be off the menu altogether as long as you know what is is called (supposed it is called "Validation", then you can access it via yourdomain.com/index.php?pr=Validation).

[aravan]

Hello all. I've seen this mentioned in several threads but am not sure what the actual solution is. Someone help please???

edit: Somehow I managed to get this to work but now I have another question.

Is there any way to edit the standard validation emails that are sent out to change the wording???

[DrJon]

I'm assuming you mean from things like contact forms; yep, if that's the case, you can easily.

I create a file called response.txt and upload it to public_html/media folder.

When you drop a form on a page on the right hand side of the window there is a drop down box called 'c. Content of Auto Email' - as long as I've already uploaded the response.txt file it will be shown in this drop down box; select this file and complete the rest of the steps to drop the form on the page.

When someone submits a form from the web site, as long as the form hase been crrectly structured, they get the contents of this file as the email.

Simple, eh :cool: ?