Ultimate SCO URLs, Ultimate SCO URLs & new account creation

[jasontallon]

Hi

 

I have just installed Ultimate SCO URLs along with Active countries and PWA

 

Active countries is working fine clients can create an account when SCO URLs is deactivated through admin

 

When I activate SCO URLs in admin and try to create an account in the shop after completing the form and pressing continue a page desplays with the following

 

0 -

 

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('0', '0', now())

 

[TEP STOP]

 

In admin the account is created but when I goto edit the account the following error appears at the top of the screen

 

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/jmcsoft/domains/voipnetshop.co.uk/public_html/admin/includes/classes/object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in /home/jmcsoft/domains/voipnetshop.co.uk/public_html/admin/includes/classes/object_info.php on line 18

 

Does anybody have experience of this

Does anybody have an idea about resolving this issue as I would dearly love to get SCO working.

 

Thanks

 

Jason

[Guest]

I don't think it has to do with ultimate seo urls. This is more likely due to some incorrect integration with pwa perhaps. The system tries to insert a 0, where the customer_id should be valid because it was just created from these lines in create_account.php

 

tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

$customer_id = tep_db_insert_id();

 

Few lines down is the code you said that causes the problem

tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())");

 

Now if you don't have these line there, something seriously is wrong with your code.

[jasontallon]

I don't think it has to do with ultimate seo urls. This is more likely due to some incorrect integration with pwa perhaps. The system tries to insert a 0, where the customer_id should be valid because it was just created from these lines in create_account.php

 

tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

$customer_id = tep_db_insert_id();

 

Few lines down is the code you said that causes the problem

tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())");

 

Now if you don't have these line there, something seriously is wrong with your code.

 

 

Yes the code is there alright. in create_account.php

 

I am not sure SCO is the problem but when I deactivate it in admin all works fine.

 

Jason

[jasontallon]

Yes the code is there alright. in create_account.php

 

I am not sure SCO is the problem but when I deactivate it in admin all works fine.

 

Jason

 

Hi

 

Thanks for the help from those who replied.

 

Got the solution and all is working fine now

 

For reference

 

in includes/classes/seo.class.php Chnage at the begining of the file <? to <?php

and in includes/configure.php Change define('USE_PCONNECT', 'true'); to define('USE_PCONNECT', 'false');

 

Jason