Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

Add More Fields


122 replies to this topic

#61 apolyshow

  • Community Member
  • 242 posts
  • Real Name:Andreas
  • Gender:Male

Posted 09 January 2012, 20:51

Has anyone install the 1.3 version to a 2.3.1 shop? Cause this files are for 2.2 and makes a mess in admin panel...
One amateur made the Arc, 5.000 pro made the Titanic...

#62 booksfromhome

  • Community Member
  • 32 posts
  • Real Name:David
  • Gender:Male

Posted 09 January 2012, 21:10

I have a basic question on step #2 of the install (1.3) for V2.3

What is the catalog_new_files_only? for new install only?

Also, I saw in the forum the some people questioned line 470 and 756, your comment
was to skip them, that comment scares me. Should I follow all the install
steps or not??

Edited by booksfromhome, 09 January 2012, 21:13.


#63 apolyshow

  • Community Member
  • 242 posts
  • Real Name:Andreas
  • Gender:Male

Posted 09 January 2012, 22:37

No defenetely no . It cause a crash in my database and now i can't get in...
One amateur made the Arc, 5.000 pro made the Titanic...

#64 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 10 January 2012, 00:14

View Postapolyshow, on 09 January 2012, 20:51, said:

Has anyone install the 1.3 version to a 2.3.1 shop? Cause this files are for 2.2 and makes a mess in admin panel...
Yes, it works fine. You have to use the 2.3 install directory if you have a 2.3 shop.

#65 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 10 January 2012, 00:16

View Postbooksfromhome, on 09 January 2012, 21:10, said:

I have a basic question on step #2 of the install (1.3) for V2.3

What is the catalog_new_files_only? for new install only?
The instructions state, "Upload all of the files in the catalog_New_Files_only directory." Do you not understand what that sentence is saying? I'm not sure how else to explain the step.

#66 booksfromhome

  • Community Member
  • 32 posts
  • Real Name:David
  • Gender:Male

Posted 10 January 2012, 22:05

under the later than 2.3 folder is a catalog folder and a catalog_New_Files_only folder

under the catalog folder is a admin folder and a product info file
under the catalog_New_Files_only folder is a admin folder and a include folder

#67 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 11 January 2012, 01:51

View Postbooksfromhome, on 10 January 2012, 22:05, said:

under the later than 2.3 folder is a catalog folder and a catalog_New_Files_only folder

under the catalog folder is a admin folder and a product info file
under the catalog_New_Files_only folder is a admin folder and a include folder
One if for new filed from this contribution. The other is for existing files in case you want to compare them or use them on a new shop.

#68 booksfromhome

  • Community Member
  • 32 posts
  • Real Name:David
  • Gender:Male

Posted 14 January 2012, 19:00

here we go again..

I am looking over the install of (1.3) for V2.3.1

I can not locate "around 470" "around 756" and "around 823"

I have a copy of oscommerce 2.3.1 from VODAHOST and the only other add on I have googlefeed 2.9

#69 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 15 January 2012, 01:12

View Postbooksfromhome, on 14 January 2012, 19:00, said:

here we go again..

I am looking over the install of (1.3) for V2.3.1

I can not locate "around 470" "around 756" and "around 823"

I have a copy of oscommerce 2.3.1 from VODAHOST and the only other add on I have googlefeed 2.9
The line numbers are approximate and may not match your file for a number of reasons. There are completed files in the package that you can compare against though.

#70 wooha

  • Community Member
  • 1 posts
  • Real Name:Jesse

Posted 16 January 2012, 23:24

Thanks for this Contribution.


I have the contribution installed, and can see the "added fields" from the products edit page.

However I do not see it displayed in the actual webpage,

I also tried adding a field called ##+TEST1##- just playing around but now it says

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 '' at line 1

alter table products_description drop ##TEST1##-

[TEP STOP]


when i try to delete

and it says

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 '' at line 1

select ##TEST1##- as field_value from products_description where products_id = 7 and language_id = 1

[TEP STOP]


it or go edit my products. I'm still very new at this :( Any help would be appreciated!

Edited by wooha, 16 January 2012, 23:26.


#71 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 17 January 2012, 00:00

View Postwooha, on 16 January 2012, 23:24, said:

Thanks for this Contribution.


I have the contribution installed, and can see the "added fields" from the products edit page.

However I do not see it displayed in the actual webpage,

I also tried adding a field called ##+TEST1##- just playing around but now it says
When you add a field, there is a field name and a display name. For the field name, it needs to be letters and numbers, no spaces or special characters. The display name can be anything (probably) but it would make more sense to name it similar, or the same as, to the field name. So, in your example, the field name could be test1 and the displayname could be Test 1. In the products edit page when you add it to the description, you use the display name in all capitals, which means it would be ##+TEST 1##-

#72 OSC_FREAK

  • Community Member
  • 29 posts
  • Real Name:osc_freak
  • Gender:Male
  • Location:Netherlands

Posted 18 January 2012, 13:23

does this addon also adds more fields to the field products_name?

#73 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 18 January 2012, 13:52

View PostOSC_FREAK, on 18 January 2012, 13:23, said:

does this addon also adds more fields to the field products_name?
I'm sorry but I don't understand your question. But taking it as stated, you can't add a field to field, even if you edited the database directly.

#74 booksfromhome

  • Community Member
  • 32 posts
  • Real Name:David
  • Gender:Male

Posted 21 January 2012, 20:47

I hate to keep bugging you about this but its important to me.

If I search for line 470 "elseif (temp_not_null)" in your completed files (admin/categories.php) there are no lines that have have "elseif (temp_not_null)"

what am I missing

#75 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 22 January 2012, 01:10

View Postbooksfromhome, on 21 January 2012, 20:47, said:

I hate to keep bugging you about this but its important to me.

If I search for line 470 "elseif (temp_not_null)" in your completed files (admin/categories.php) there are no lines that have have "elseif (temp_not_null)"

what am I missing
Maybe you are using the wrong version for your oscommerce version. Or maybe you are using instructions which contain a mistake, as covered in this thread. Ot maybe that file has been edited and no longer resembles a standard file.

#76 booksfromhome

  • Community Member
  • 32 posts
  • Real Name:David
  • Gender:Male

Posted 22 January 2012, 01:47

If I look at your "AddMoreFields_V_1.3\Use_if_version_greaterthan_2.3\catalog\admin/categories.php" there is no lines that have have"elseif (temp_not_null)"

If I look at your "AddMoreFields_V_1.3\Use_if_version_lessthan_2.3\catalog\admin/categories.php" IT IS THERE

do I just have the wrong instructions?

#77 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 22 January 2012, 03:07

View Postbooksfromhome, on 22 January 2012, 01:47, said:

If I look at your "AddMoreFields_V_1.3\Use_if_version_greaterthan_2.3\catalog\admin/categories.php" there is no lines that have have"elseif (temp_not_null)"

If I look at your "AddMoreFields_V_1.3\Use_if_version_lessthan_2.3\catalog\admin/categories.php" IT IS THERE

do I just have the wrong instructions?
This has been answered.

#78 Bjorn Jacobs

  • Community Member
  • 1 posts

Posted 28 January 2012, 19:32

I used all the files in the package, i have a clean installation without any other contributions, so it has to work just fine...

Now, it is working just great, but on the "Catalog->Add more fields" page i'm getting the menu twice.
Once as it is normally in the admin panel, and once just all the links beneath each other...

Spoiler


#79 Jack_mcs

  • Community Member
  • 24,453 posts
  • Real Name:Jack
  • Gender:Male

Posted 29 January 2012, 01:23

View PostBjorn Jacobs, on 28 January 2012, 19:32, said:

I used all the files in the package, i have a clean installation without any other contributions, so it has to work just fine...

Now, it is working just great, but on the "Catalog->Add more fields" page i'm getting the menu twice.
Once as it is normally in the admin panel, and once just all the links beneath each other...
I'm not sure I understand the problem but if you used the completed files, all I can think of is that you used the wrong version or there is some mistake in them I am not aware of.

#80 psytanium

  • Community Member
  • 18 posts
  • Real Name:Ludwig Arcache
  • Gender:Male
  • Location:Lebanon

Posted 14 February 2012, 03:01

Hi, i did all the required steps, using the greaterthen 2.3 version on my 2.3.1 shop.
i reached the step where i have to find
} elseif (tep_not_null($HTTP_POST_VARS)) {
	  $pInfo->objectInfo($HTTP_POST_VARS);
	  $products_name = $HTTP_POST_VARS['products_name'];
	  $products_description = $HTTP_POST_VARS['products_description'];
	  $products_url = $HTTP_POST_VARS['products_url'];

but i didn't find a single piece of it. can you guide in this procedure ?
Thanks!!