1 Topic by ssuch

  • ssuch
  • Member
  • Offline

Topic: HELP! Vendors do not appear when I Add Item

OK, I hope this is all clear enough.

When I Add a new Vendor, the new vendor appears on the pull-down list on the front page, on the pull-down lists on other pages (via bottom_part.php), and when you view all vendors (via vendors.php).

However, the new vendor does NOT appear on the "Vendor" pull-down menu on the form that appears when you "Add Item".

To complicate matters, a couple of weeks ago I added maybe 20 Vendors and of these 15 DO appear in the pull down menu when you add a new item but 5 do not.  But if you then edit any of those that appear, they then  disappear from the "Add item" form pull-down.

I don't know what I've done between 2 weeks ago and now.  My only theory is that I have not configured the "Vendor" field correctly in  Interface Creator for the table "Items".  I accidently re-installed the Items table which blanked out all the settings and so have had to re-configure each field.  Everything else is working great.  It was only when we needed to add a new vendor that the problem revealed itself.

2 Reply by testly

  • testly
  • Member
  • Offline

Re: HELP! Vendors do not appear when I Add Item

I have not seen such an issue. Most likely you faced the problem because of that re-installation.

3 Reply by ssuch

  • ssuch
  • Member
  • Offline

Re: HELP! Vendors do not appear when I Add Item

Update,

So when I just restart the server all of the new vendors appear in the "Insert Item" window.  However, if I then add or edit vendors the new/edited vendors do not appear.  They do, however, appear everywhere else and are definitely in the 'vendors' table.

Any ideas? 

It is not practical to go and restart the server every time we add a new vendor.  All other items/orders update perfectly fine.  I really don't know what to do or what to look for.

Steve

4 Reply by testly

  • testly
  • Member
  • Offline

Re: HELP! Vendors do not appear when I Add Item

Though doubtful, could the problem be this: new vendor is added and it gets into database. But a page previously opened to insert an item (or list vendors) is not refreshed and naturally the new vendor is not there.

5 Reply by ssuch

  • ssuch
  • Member
  • Offline

Re: HELP! Vendors do not appear when I Add Item

Update again,

I think the problem is solved.  I did two things - not sure which one was more important.

Firstly,  I checked through the data entries I already had in the Vendors table and found one with the Update Field set to 00-00-000. (this was the example entry that was initially in the database and which I had neglected to delete).  When I deleted this entry and restarted the server, I could add Vendors and they would appear when in the Add Item form.  Voila, I thought!  However, after I added several new vendors, or if there was some time (eg couple of days) between adding vendors  then the problem reverted and new vendors wouldn't appear.  Hence, I would have to restart server.

Secondly, I checked again the formatting of the Vendor field for the Item table in Interface Creator.  The primary key table I had reconfigured to 'Vendor'.  When I changed this to 'vendor' everything seemed to work.  Since I did this everything seems ok.  fingers crossed

Do either of these seem likely explanations?

6 Reply by testly

  • testly
  • Member
  • Offline

Re: HELP! Vendors do not appear when I Add Item

MySQL table names are case sensitive, so using 'Vendor' instead of 'vendor' may indeed have been the reason.