Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Saturday, October 12, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Error message mentioning "PMEtable0" [LONG]

phpMyEdit Installation     Error message mentioning "PMEtable0" [LONG]
Post new topic   Reply to topic    
 
cjraven     Joined: 13 Aug 2003   Posts: 2  
Post Posted: 2003-08-13 15:49
Back to top  Reply with quote     

Hi there!!
A GREAT app, or at least I hope I still think so once I get it working.!! :-)

I have one apparently unsolveable problem (the long part) and one question
Problem
Anyway, phpMyEdit is in place, setup.php was run, and because it's a virtual site (and FP2000 administered in many parts) permissions were insufficient to create item.php, so I cut and pasted the results of the setup program manually into a file of the same name. Good so far.

Then I attempted to call "item.php" from the browser I got a table outline, but a huge error message at the top of the page as shown below:
---------------------------

item
MySQL error 1109
Unknown table 'PMEtable0' in field list
phpMyEdit error: invalid SQL query
---------------------------
SELECT PMEtable0.id AS qf0,
PMEtable0.category AS qf1,
PMEtable0.item# AS qf2,
PMEtable0.descr AS qf3,
PMEtable0.cost AS qf4,
PMEtable0.avail AS qf5 FROM item AS PMEtable0 ORDER BY PMEtable0.category DESC,PMEtable0.id LIMIT 0,1515.173 miliseconds
---------------------------
Now, my db is called "stuff" and the single table within it is called "item" and has no data in it currently. There are 6 fields:
id (bigint, 20) auto-increment primary key
category (text)
item# (int,11)
descr (text)
cost (float)
avail (int, 11)

I wanted to find out where it was getting a field list which referenced a table called; "PMEtable0" and I found many mentions of it in phpMyEdit.class.php
SO
What must I do?
replace instances of "PMEtable0" with table_name (in this case "stuff")?
do something else magical?

Question:
One of my fields is called "category" and I'd like to be able to display that as a drop down list (I don't want users inventing new categories, just use existing ones) Thus, would it be better to join another table called "Categories" to the main table, then when data entry takes place, the existing records in "table_categories" would be shown and the results could load directly into table_item.

Thanks for your patience everyone *and* a great application. Looking forward to taking my first steps in php/MySQL.

Sorry if this was long, but I'm new to all this and also (needless to say) stumped.

Regards & TIA,
-Colin

 
cjraven     Joined: 13 Aug 2003   Posts: 2  
Post Posted: 2003-08-14 11:42
Back to top  Reply with quote     

I accidentally double posted.
Apologies - sorry sorry
Obviously I was a bit more apprehensive than I thought.

 
nepto     Joined: 06 Jan 2003   Posts: 381   Location: Phoenix, Arizona (USA)
Post Posted: 2003-09-20 17:49
Back to top  Reply with quote     

Problem is with your field item# . Try to avoid strange names like this one. You could rename it to simple item and phpMyEdit will work properly than.

 
jezina     Joined: 13 Feb 2021   Posts: 1  
Post Posted: 2021-02-13 08:59
Back to top  Reply with quote     

Platon technologies are the working technology for the proper relational of the different argument patches. The PHP edit post has the different idea of easyessay for the installation of error in the working and co working space for the alarming situation at any time for good deed.

 
tezib     Joined: 13 Mar 2021   Posts: 1  
Post Posted: 2021-03-13 08:33
Back to top  Reply with quote     

Yes, the value of the wig is generated or the mid for all stances for shows. Paths of the field and chemo hats are acute for all forms. The Mach is fit for the approval of the guile in the mid of the terms for parts for the users of the wigs.

 
ljglmail     Joined: 20 Dec 2021   Posts: 15  
Post Posted: 2021-12-20 08:05
Back to top  Reply with quote     

Ok, so it's happened. You have a few hundred PDFs on your site, and you've decided to use the PME method to display them. You are in the middle of the conversion process when all of a sudden you get an error message saying: "Error: Table './softaculous/pmEtable0' doesn't exist". You are puzzled because you are positive that the table exists. So, you dig deeper into the error log file, but there is nothing there that will lead you to the solution.

What can you do now?

Well, for starters, you can log into phpmyadmin and see whether or not the table exists. Chances are, it does exist and you simply need to create a new index for it. But what if it doesn't? That's when things get a little more complicated.

The first thing that you should do is check your installation script for any errors. If there were any errors during your installation process then chances are that one of them may have caused this issue. The most common error is an invalid database username or password. Make sure that you enter your MySQL credentials correctly during installation and rerun the installation again to see if this solves the problem. https://www.tcswebmail.info/ https://www.upsers.fyi/ https://www.prepaidgiftbalance.fyi/

 
sannyloi22     Joined: 07 Sep 2022   Posts: 55  
Post Posted: 2023-01-05 05:36
Back to top  Reply with quote     

We use only the highest quality parts and equipment.

Tallahassee Mobile Mechanic

 
Post new topic   Reply to topic    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy