Jump to content
The Uniform Server Community

Heinz Stapff

Member
  • Posts

    78
  • Joined

  • Last visited

Everything posted by Heinz Stapff

  1. Thanks again BobS, what a difference the file path makes. Even though search companion found my.ini I would not have known that it was not part of phpadmin but the control that phpadmin uses, amends or writes to in mysql? If phpadmin can write to my.ini and my.ini in mysql controls the database production then you can control InnoDB format from phpAdmin though InnoDB(It has to be enabled in my.ini) appears to lack a key feature of MyISAM in that there is no Auto-increment for Primary Key interger on colum index like Category_ID? I guess this should be explained in another topic Like InnoDB vs MyISAM which is pritty exhausted on the web but dosen't relate entirely to UniServer and phpAdmin which pfd file I'm about to start reading as soon as I reinstall a new version of php to match the eAccelerator. PHP VER 5.3.5.0 where as the eAccelerator requires PHP 5.3.6.0???????????? Confussion is an understatement for most students though the anology(more advanced) is well taken.
  2. Hi, just posted this in Apache forum and wasn't sure whether or not it should be PHP. Please let me know in any resonse. "Yeah, I'm a little suprised that I found this in the Apache error log as I've been working on MySQL and had not checked Apache but the error log is continually reporting this in Apache: [eAccelerator] This build of "eAccelerator" was compiled for PHP version 5.3.6. Rebuild it for your PHP version (5.3.5) or download precompiled binaries. I believe that was right out of the box and that I have not changed the php version. It might be the version actually running on the PC but I did not know there was one. As I haven't started loading site files to Uniserver folders in D:/ sould I just download the latest Uniserver.exe and start again or is there a PHP.exe running on my PC that has it's own version? Any help greatly appreciated. "
  3. Yeah, I'm a little suprised that I found this in the Apache error log as I've been working on MySQL and had not checked Apache but the error log is continually reporting this in Apache: [eAccelerator] This build of "eAccelerator" was compiled for PHP version 5.3.6. Rebuild it for your PHP version (5.3.5) or download precompiled binaries. I believe that was right out of the box and that I have not changed the php version. It might be the version actually running on the PC but I did not know there was one. As I haven't started loading site files to Uniserver folders in D:/ sould I just download the latest Uniserver.exe and start again or is there a PHP.exe running on my PC that has it's own version? Any help greatly appreciated.
  4. Thanks again BobS I'm runing MySQL fine as a program now that Uniserver is installed in D:/ actuall it always did as a program. I also have Workbench running fine though after the first Forward Engineering process the Forward Engeering option disapeared from Home/Database/options so I wasn't able to submit another revision. I'm wondering if it will let me when I restart Workbench as I might have to change the data engines back to MyISAM from InnoDB? Stranglley enough, if you new enough sql you can use the comand line prompt from Workbench by right clicking Home/Conection and clicking Comand line in the popup menu. The help tutorial showed you how to and you have to enter the Uniserver password before you can enter sql comands like FROM MYDB; SHOW TABLES; etc. It was recomended as a test of the Forward Engeneering. The other thing you mentioned about phpadmin not using InnoDB, does that mean PHP scripts can't be used on InnoDB or just that they won't be applicable via phpadmin? That I really do have to know.
  5. DOES THAT MEAN THAT PHP WON'T BE USABLE TO ACCESS INNODB? POSSIBLY ANOTHER FAULT WITH INNODB?
  6. BobS Thanks again and though you are right about the learning curb in any program the terminology is relevent and the difference between column and field are quite distinct as sql uses col or column in the scripting I believe it should be a priority in the UI. The my.ini info was excelent but lacked the directory path phpadmin/my.ini? Not sure about the path but search companion found it. Completed Innodb # skip innodb. If you want to comunicate between 3 databases then it is ok that all the tables be in one folder ie. innodb folder though I understand that adding other innodb.dbs would deffinatley be a problem. Maybe they could be placed in sub directories but after creation would be a problem even though I'm sure there is a sql statement for create new folder. That is one thing the Inno propaganda failed to mention, where were you BobS in that comentary? MyISAM deffinatley smells better after that info. Muchos gracias senoir.
  7. BobS Thank you too and I've just downloaded the pdf recomended by megan and I would say that the difference between the two at first glance, is that Workbench actually uses columns not fields as terminology. Insert rows etc. are far easier to use though not that clear at least they appear directly under the column headers/fields and not as separate tab inputs? Also, I personally find writing any script including sql in a scrollable text area not an input box a lot easier though this maybe applicable in phpadmin it isn't clear how to do it. I haven't completely tried either programs so I'm a little in the dark though I do believe that when you obtain any ability you should be able to write the complete db script in yourself. Both programs may or may not have this ability directly. Workbench allows you to do this in the wizard popup pages for each step. I guess your telling me that when running Uniserver on Windows XP as a service screws up the name of the process and that I should run it as a program to get it right. However I'd like to know what the fix is to run it as a service? Thanks again for your help.
  8. megan THANKS AGAIN, MISSED YOUR PASSWORD THE FIRST TIME!
  9. Thanks megan will check out the link too. I have to say that I'm not overimpressed with phpadmin's ability to create tables as there maybe more cell input type ability there doesn't seem to be column creation and row insertion easy like MySQL Workbench and you don't seem to be able to write your own sql which the workbench lets you edit as you go through the wizard. Not as direct as writing your own sql but that should be provided.
  10. How do I delete a database? I need to start all over again. phpadmin doesn't seem to allow it or maybe I'm missing it. I'd also like to know how to enable Innod.db as the log said it was disabled?
  11. Heinz Stapff

    PHP UPDATE

    Checked Apache server logs and keep getting this: [eAccelerator] This build of "eAccelerator" was compiled for PHP version 5.3.6. Rebuild it for your PHP version (5.3.5) so I guess I need to know how to reinstall php as 5.3.6 before I even start loading files. Any advice on how to do this greatly appreciated.
  12. Trying to create database for products sold on site and need some advice as this is my first time. What folder is a database created in? Does phpadmin help create databases? Does using MySQL Workbench make sence? Once created what is the best interface to manipulate and view the tables? Any advice greatly appreciated. I was thinking MySQL Workbench for the grunt work and Microsoft Acces for the finaly. I have an exel sheet with product information and would require that client information including ordering be on a seperate db. Maybe three dbs, one for orders only.
  13. megan I just figured out you can use it to create the database but the real issue was running MySQL Uniserver as a service on my pc. I originaly had a test site folder in MyDocs and foolishly downloaded Uniserver.exe to that folder thinking it would be easier to move files etc. Windows Xp Pro SP3 has spaces in 'My Docs' etc. file paths. Uniserver could not run as a service in this environment. All link file paths would have to be double quoted to make it work as a service and the true beauty of Uniserver, portability, would never be obtained. Also MSQL Workbbench required that MySQL ran as a service, not a program. I deleted the Uniserver folder in the site folder and moved the Uniserver.exe to USB thumb drive 7.44GB Kingston Data Traveler USB2.0. Clicked the Uniserver.exe and installed to D:/ wich has no spaces in file paths when running in XP. Clicked on Start.bat and the Uniserver Tray icon poped up no problem which meant that you can run both MySQL and Apache as a service. After runing them as services I opened MySQL Workbench and a Server Instance was already loaded. mysqld. The new problem is that it links directly to my.ini in the Uniserver folders on D:/ and now have to decide wheather or not to add tables, shemas etc. to an already loaded database folder which I take it are the files that phpAdmin modifies to create the database. Please let me know if it is easier to use phpadmin to create databases. I'm totaly in the dark and MySQL Workbench has a learning curb.
  14. OOPS![/u] not resolved! After hiting the next button in MySQL Workbench when all the conections are checked correctly a popup alert stating that MySQL server must be installed as a service and obviously not as a program. Does anybody know how to install Uniserver on Windows XP sp3 as a service? I couldn't figure out how to put it in a folder without file name spaces which is requiered to run Uniserver as a service!? I think. Any help greatly appreciated.
  15. I figured it out and got conected with MySQL Workbench 'New server instance' wizard localhost, click next button, when password dialogue box pops up enter 'root' and presto your in action. Should be able to set up base schema now. Two hours latter. Hope anybody else gets this post, I was litterally going postal.
  16. I downloaded, installed MySQL Workbench and ran it but can't conect to Uniserver with 'New server Instance wizard' as localhost. Is this because Apache MySQL is uncompatible or am I doing something wrong. Uniserver is running but may not be as a service? I had to use run_ondrive_w.bat to run it in windows xp sp3 because I couldn't figure out how to install it to a file path without spaces. Any help greatly appreciated. Am I even in the ball park? I'm trying to create a database.
  17. Thanks for the tips, downloaded both files, the html file unzipped generated another file I had to unzip and that created the php_chunk file folder. I searched for index.html in that folder and chose out of a long list exactly 'index.html' when I clicked on it the browser opened to PHP MANUAL with excelent links to PHP info. I then added it to my Favorites as PHP manual. Maybe I should just keep the .chm and clear some space on the hard drive? Seems like a whole lot of html files in the chunk folder? Funny that the .chm file requires an internet connection to run but It would be overload so I guess I have a whole lot of studying to do!
  18. Thanks Coral and Bobs I will try both files .chm and the .html and get back.
  19. Coral I just deleted and re downloaded the file unzzipped and clicked on php_bigxhtml.html file and it automaticaly froze the system. Taskmanager showed it was using 100% of the CPU again! I'm guessing the file is corrupted or just to large? Or does it have to be placed in a Uniserver folder first for it to run? If so, which one?
  20. Hi Coral Got your message earlier but could not access the forum earlier from the link. Maybe because I had not loged out last time? I don't log out normaly so that when I get notification I don't have to log back in. This works on some forums? I believe I accessed the php manual from sourceforge.com which directed me to a mirror site in Mexico for the download. I've been trying to record the addresses of the sites in my notebook/diary as I haven't set the history in IE8 past today when clearing the cache every couple of hours to test the website localy. Unfortunatley I don't have the recorded UL this time as I had attempted it more than once after it failed to open more than once. Maybe I should have used a California mirror but probably did the first time with the same result. I'll delete the file and try the download again from php.com! found it 'http://mx2.php.net/download-docs.php' which redirected me to a page for from/a/mirror I chose 'mx2.php.net' Universidad Autonoma Metropolitana as mx2 applies to the original site. The file I downloaded is 'php_manual_en.html.gz'
  21. Hi, downloaded PHP manual HTML zip file and unzipped it to desktop folder 'PHPMANUAL'. When I open the html file the browser displays a blank page and TASKMANAGER shows that 100% of the CPU usage is taken up. As I need to know more about using PHP I could realy use this manual. WINDOWS XP SP3 1 GIG OF MEMORY MAY BE THE PROBLEM. OR IS IT A PAGE FILE SIZE PROBLEM? Any help greatly appreciated.
  22. boBs Thanks for the link. I had not acctualy set up the site on the server 5.0 Nano but had changed the db and apache passwords so I was getting the afformentioned error: and had to change the passwords back to root:root before I could delete the Nano server and run the latest server! Will have to use your info next time. Thanks again!
  23. THANKS AGAIN CORAL, QUICK READ THROUGH THE LINKS AND REALIZED I WAS PARANOID. I COULD HAVE RUN THE SERVER AND NOT HAD A PROBLEM AT ALL LOCALHOST! I ALSO NOTICED THAT JUST BECAUSE I ADDED THE PASSWORDS IN THE APANEL TO ALL THE SERVER TYPES (MYSQL DIDN'T TAKE BECAUSE NO DATABASE WAS ADDED?) DOSEN'T MEAN THEIR ACTIVATED UNTILL YOU DO SO IN THE APPROPRIATE FILES. AS I AM ONLY TESTING THE SITE LOCALY AND THEN SENDING THE FILES I CREATE TO THE GODADDY SITE. QUESTION FOR INSTALLING UNISERVER 7.0 OR LATEST UDATE. HOW DO YOU REMOVE THE PREVIOUSE VERSION? WHEN I TRIED TO OVERWRITE THE ORIGINAL UNISERVER FOLDER BY MOVING THE NEW ONE TO THE OLD ONES FOLDER IT GAVE AN ERROR:CAN NOT DELETE APACHE.EXE PASSWORD PROTECTED? WHICH I GUESS MEANS THE PASSWORDS I SET THE OTHER DAY NEED TO BE RESET THROUGH THE APANEL BACK TO 'ROOT'?
  24. Thanks Coral, will check it out. Just downloaded updatede Uniserver 7.0 and tried to delete 5.Nano and realized I have to change all the passwords back to root before I can delete Apache.exe etc. Looks similar including the run_on_drive_w.bat I figured out that you have to double click on that, not start.exe to get it running after you copy it from alternative_controls folder to the Uniserver folder. Yeah the instructions are light-weight too but they are all there. It never helps to be in a hurry and speed reading through the docs files two or three times hasn't helped this cranium much
  25. OK. I MOVED THE UNISERVER BACK TO THE DESCKTOP? WHEN I CLICKED START.EXEC I AM STILL GETTING THE ERROR:UNABLE TO START UNITRAY A SPACE WAS DETECTED IN PATH TO FOLDER ETC. UNFIFORM SERVER V5-NANO SERIES C:\Documents and Settings\Administrator\Desktop\UniServer 'DOCUMENTS AND SETTINGS\' SEEMS TO BE THE PROBLEM WITH THE FILE NAME SPACE SO I GUESS I WILL HAVE TO RUN run_on_drive_w.bat IN WHICH EVER FOLDER I RUN THE SERVER FROM IN WINDOWS XP SP3. THAT MEANS I CAN'T RUN THE SERVER AS A SERVICE? ANY WAY AROUND THIS? AGAIN, ANY HELP GREATLY APPRECIATED! COULD I CHANGE 'DOCUMENTS AND SETTINGS' TO DOCUMENTS%20AND%20SETTINGS/' OR SOMETHING LIKE THAT?
×
×
  • Create New...