Latest News: (loading..)
alenkij

Imprint Text Options

332 posts in this topic

I've rechecked my install for any mistakes I may have made but can't find anything, please can anyone point me in the right direction? I'm fairly new to oscommerce so any help will be much appreciated, thanks in advance!

Go to google and type this in the search box:

site:forums.oscommerce.com Fatal error: Cannot redeclare _sess_open()

Share this post


Link to post
Share on other sites

Go to google and type this in the search box:

site:forums.oscommerce.com Fatal error: Cannot redeclare _sess_open()

 

Thanks for your swift reply - I've already googled this and can't find anything that looks like it could be useful. Everything else in Admin/Catalog is working OK, just the new 'Text Attributes' that produces this error.

Share this post


Link to post
Share on other sites

Can someone help me with this error:

 

Error: Undefined index: products_text_attributes_text

File: product_info.php

Line: 328

 

How can I fix this?

Share this post


Link to post
Share on other sites

Hi,

 

Just installed the mod but getting errors. Not sure where to start!

 

Below is error

1146 - Table 'MYDATABASE NAME HERE.products_text_attributes' doesn't exist

 

select pta.*, cbta.products_text_attributes_text from products_text_attributes as pta, products_text_attributes_enabled as ptae, customers_basket_text_attributes as cbta where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = 32 and cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.session_id = '4a644215f86adaacec4952cc13b2b63c'

 

Your help is deeply appreciated

Share this post


Link to post
Share on other sites

Below is error

1146 - Table 'MYDATABASE NAME HERE.products_text_attributes' doesn't exist

The answer totally depends on the actual error.

Share this post


Link to post
Share on other sites

The answer totally depends on the actual error.

 

Do you think that something in the contrib is not matching my the sql uploaded to database?

 

Here is some more of the errors on other pages relating to the contrib install:

 

After adding product to cart:

1146 - Table 'MYDATABSE NAME.customers_basket_text_attributes' doesn't exist

 

select cbta.*, pta.products_text_attributes_name from customers_basket_text_attributes as cbta, products_text_attributes as pta where cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.products_id = 89 and cbta.session_id = ''

 

[TEP STOP]

Edited by fan4chevy

Share this post


Link to post
Share on other sites

1146 - Table 'MYDATABSE NAME.customers_basket_text_attributes' doesn't exist

Well, I doubt that the actual error says MYDATABSE NAME but since you've posted it twice, even after I asked for the real error, I assume that is the real error. And in that case, the code in your shop has a major problem and nothing to do with this contribution. You should post in the general support thread for assitance.

Share this post


Link to post
Share on other sites

Well, I doubt that the actual error says MYDATABSE NAME but since you've posted it twice, even after I asked for the real error, I assume that is the real error. And in that case, the code in your shop has a major problem and nothing to do with this contribution. You should post in the general support thread for assitance.

 

 

Thank you for your help. Actually I was just removing the personal site information and leaving it general for security purposes which is why I put MYDATABSE instead of the actual.

 

The resolution was actually a database issue which is now resolved. Thanks again.

Share this post


Link to post
Share on other sites

Anyone know if there is a way that I can have the boxes taller to where the customer can have more room to write with more than one line of text?

Example:

 

Here is beginning text

rest of text

 

Currently if I try to hit enter button it actually adds to the cart and goes to shopping cart.php

 

Also wondering how to make the box longer. Currently it appears to only hold 20 text.

Edited by fan4chevy

Share this post


Link to post
Share on other sites

Hey Jack

Having an issue with the text attributes not showing in Admin / Orders... Can you take a look and see what the heck I'm doing wrong..

Data is in the database.. Also not showing on the invoice..

Here is the section of my admin/orders.php

 

 

<?php
   for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
     echo '          <tr class="dataTableRow">' . "\n" .
          '            <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
          '            <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];

     if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {
       for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
         echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
         if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
         echo '</i></small></nobr>';
       }
     }
// denuz text attr

//      $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");
     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");
     $pid = tep_db_fetch_array($pid_query);
     $attr_q = tep_db_query("select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $HTTP_GET_VARS['oID'] . " and ota.products_id = " . $pid['products_id'] . " and pta.products_text_attributes_id = ota.products_text_attributes_id");
     while ($attr = tep_db_fetch_array($attr_q)) {
       echo '<br><nobr><small> <i> - ' . $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text']);
       echo '</i></small></nobr>';
     }

// eof denuz text attr	 

Edited by Oggster

Share this post


Link to post
Share on other sites

Hey Jack

Having an issue with the text attributes not showing in Admin / Orders... Can you take a look and see what the heck I'm doing wrong..

Data is in the database.. Also not showing on the invoice..

If the data is in the database, then there must be a mistake in the code changes for the orders page. An edited file is in the contribution. Use it to verify the attributes show up. If they do, then use a compare program to find the problem.

Share this post


Link to post
Share on other sites

If the data is in the database, then there must be a mistake in the code changes for the orders page. An edited file is in the contribution. Use it to verify the attributes show up. If they do, then use a compare program to find the problem.

 

I even uplaoded the orders.php file in the contribution to test.. and it would not work either.. I am runing MS2...

Would love to get this working.. I know I'm 90% there..

 

THanks for your help..

Edited by Oggster

Share this post


Link to post
Share on other sites

Hello:

 

I've been working all day on installing this contribution. I'm not getting any error messages, but the contribution is simply not working. I see the text attributes in my admin, and in the product editing the fields for it appear. On the other hand, I am not getting the price field for the product, and it changes it to 0.00, and when I choose a text attribute option, it does not show up on the product either.

 

I have triple checked my work. Used winmerge to compare the files before and after. I ran the Sql, I just don't know what could possibly be wrong. You can see a product after I installed the contribution, and edited it Click Here. Please Help!!! I really need something like this on my shop. Thanks So Much!!!

Share this post


Link to post
Share on other sites

I even uplaoded the orders.php file in the contribution to test.. and it would not work either.. I am runing MS2...

Would love to get this working.. I know I'm 90% there..

 

THanks for your help..

The code is using the model number to load the items in admin. Perhaps your products don't have model numbers.

Share this post


Link to post
Share on other sites

I have triple checked my work. Used winmerge to compare the files before and after. I ran the Sql, I just don't know what could possibly be wrong. You can see a product after I installed the contribution, and edited it

What happens when you try to use the included files to test with?

Share this post


Link to post
Share on other sites

The code is using the model number to load the items in admin. Perhaps your products don't have model numbers.

 

Ok fixed the product model numbers.. You were right I didn't really use them... Well, they all have them now...

 

Now I get this error on the orders.php page...

 

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 'and pta.products_text_attributes_id = ota.products_text_attributes_id' at line 1

select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 8551 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id

[TEP STOP]

Share this post


Link to post
Share on other sites

What happens when you try to use the included files to test with?

Hello:

Thanks for the quick reply :). When I used the included files, I got this message:

 

TABLE_ADMINISTRATORS' doesn't exist

 

select id from TABLE_ADMINISTRATORS limit 1

 

So then I did it manually.

 

I have some security add ons, could this intefere at all?

Thanks

Share this post


Link to post
Share on other sites

Ok fixed the product model numbers.. You were right I didn't really use them... Well, they all have them now...

 

Now I get this error on the orders.php page...

 

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 'and pta.products_text_attributes_id = ota.products_text_attributes_id' at line 1

select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 8551 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id

[TEP STOP]

 

Error Fixed by doing the following..

 

Open admin/invoice.php and find the following:

// denuz text attr//      $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");      $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");
Replace with:

//      $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");      $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");
Open admin/packingslip.php and find the following:

// denuz text attr      $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");
Replace with:

// denuz text attr      $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");

Share this post


Link to post
Share on other sites

Am I correct in saying that I can only use -1- text field option per product ???

Share this post


Link to post
Share on other sites

Hello:

Thanks for the quick reply :). When I used the included files, I got this message:

 

TABLE_ADMINISTRATORS' doesn't exist

 

select id from TABLE_ADMINISTRATORS limit 1

 

So then I did it manually.

 

I have some security add ons, could this intefere at all?

Thanks

TABLE_ADMINISTRATORS is for an RC2 shop so there is a compatibility issue between your version and the version of the files in the contribution which means you can't use the files directly. I'm not aware of any issues with the contribution and the various versions of oscommerce but I suppose there could be. I think it more likely there is some mistake in the installation. But either way, I on't know what else to suggest to you to find your problem. I suppose, if you can do it, you could install a new shop in a subdirectory and install the contribution into it. If it works, then you can compare your files to find the problem.

Share this post


Link to post
Share on other sites

Am I correct in saying that I can only use -1- text field option per product ???

No, there's no limit.

Share this post


Link to post
Share on other sites

No, there's no limit.

 

When I ran a test order. I added a product with the text option to the shopping cart.. When I try to add a second different product with the text option.. The text field is filed out with the other products attribute..

So 2 products cannot be added to the cart with text options.. Unless both those products had there own assigned text attribute..

 

I hope this is making sense.. If this is the only issue I can work with it.. Just wanted to make sure its working right...

Thanks..

Share this post


Link to post
Share on other sites

When I ran a test order. I added a product with the text option to the shopping cart.. When I try to add a second different product with the text option.. The text field is filed out with the other products attribute..

So 2 products cannot be added to the cart with text options.. Unless both those products had there own assigned text attribute..

Oh, I see. I misunderstood what you meant. Yes, that is a known problem with this contribution. The work-around is to add extra options on the page so the customer can fill in more options at one time. The code will remember the previous setting so if the customer adds some text then goes back to add another, the first should still be there and they can just type in another box to add another. It is not the best of methods but until the code is fixed, it is the only one.

Share this post


Link to post
Share on other sites

TABLE_ADMINISTRATORS is for an RC2 shop so there is a compatibility issue between your version and the version of the files in the contribution which means you can't use the files directly. I'm not aware of any issues with the contribution and the various versions of oscommerce but I suppose there could be. I think it more likely there is some mistake in the installation. But either way, I on't know what else to suggest to you to find your problem. I suppose, if you can do it, you could install a new shop in a subdirectory and install the contribution into it. If it works, then you can compare your files to find the problem.

Hey Jack:

 

I will try that, and see how it goes. I really appreciate your help. Thanks.

Glenda

Share this post


Link to post
Share on other sites

If the data is in the database, then there must be a mistake in the code changes for the orders page. An edited file is in the contribution. Use it to verify the attributes show up. If they do, then use a compare program to find the problem.

 

I have the same problem, and I have compared all files.

ITO is working fine, but not showing attribs in admin area for orders, invoice and packing slip.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now