Ric

Check out this page: http://center.uniformserver.com/uniserver_...amweaver_1.html The information you are looking for is at the bottom.

I have had a quick scan of this thread. I cannot see the cause of the problem. Your code is correct: NameVirtualHost * ServerName www.theundrground.net DocumentRoot /www/ ServerName test2.theundrground.net DocumentRoot /www/forumz ServerName kalpz.theundrground.net DocumentRoot /www/kalpz I am puzzled by your test results when typing addresses into a browser: http:// www.theundrground.net http:// test2.theundrground.net http:// kalpz.theundrground.net You receive a test index page from either folder /www/ or folder /www/kalpz I assume your domain provider has enabled wildcards (CNAME) otherwise you would have received a Server not found error on two of the address. This means that any address containing your domain name *. theundrground.net is reaching your server hence not the problem area. Type any address other than the above three containing your domain name eg fred. theundrground.net Will result in each VirtualHost being checked and of course no match will be found. Apache has no problem with this it will serves pages from the default folder. The default is the first VirtualHost entry hence will server pages from WWW. It appears that only the middle address is not being recognised. That’s what puzzles me and I think it is worth checking to see what is in the hosts file Located in: C:\WINDOWS\system32\drivers\etc\ If you find any entries containing your domain name delete them. For example 127.0.0.1 test2.theundrground.net That’s my best shot for now.

I do love images and the above should scare the paints off you. Oh! It did you should have received two other messages prior to this that gave you the option to allow Apache and MySQL access to the Internet (just allow access). I assume you trusted these and did just that; well if you did not you just took yours servers off line. If what I see is true Norton has removed a valid program (SlimFTP) from your system and has not offered an option to allow you to keep the installation. This means that Norton will always remove the program so you cannot use it! You need to set Norton to allow the program (sorry I do not use this one so do not know how to do it). My reason for replying to this is simple who do you trust! If you are manic NO one! Well if you have downloaded from sourceforge.net it has been my experience no problem. Your conflict is then with whatever security you have installed. I am with Olajide on this one its normal but a pain when you receive alerts like the above image.

Have you looked at this page: http://center.uniformserver.com/virtual_ho...ual_host_1.html worth a visit. All the best

Confession time as you correctly pointed out there is no Local/Remote in the drop down menu this was a typo and appeared in several places. It should have been Local/Network I have corrected the offending pages. Your MX installation I would think is OK however please note all my tests and images were produced on XP home edition. This does not suffer with “Out of Environment Space” The MX version I used was 6.1. If you still have problems, I will try to test on a machine with your OS. All the best

I forgot to answer your original question. I think the reason why your php.ini is not seen is because UniServer runs PHP as a module hence php.ini is only used (read) when apache is started. If PHP is running as a CGI then the php.ini file is checked per request just like your service providers installation. In terms of security, there is some debate between running php as a module or as a CGI, looks as if the UniServer team has chosen running as a module. Could be wrong

An alternative to using php.ini is to use .htaccess for auto_prepend_file and auto_append_file, this example explains how. 1) In your root folder (wwww) create a new folder named atest In this folder add the following files: test.php Test page This is a test file echo " Content TEST"?> top.php TOP TEST bottom.php BOTTOM TEST .htaccess php_value auto_prepend_file "top.php" php_value auto_append_file "bottom.php" Top.php and bottom.php are not practical however they do demostrate the point. View test.php in a browser and you will see the files have been appended and prepended accordingly. 2) In the folder that you created (atest) create a new folder named test2 In this folder, add the following file: test2.php Test page 2 This is a test2 file echo "Content TEST2" ?> View test2.php in a browser and you will be greeted with an error message similar to this: Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0 Warning: Unknown: Failed opening 'top.php' for inclusion (include_path='.;/usr/local/PHP/includes;/usr/local/PHP/pear') in Unknown on line 0 The reason why this does not work is because includes (note: auto_prepend and auto_append are just fancy includes) are relative to the file that initiated them in this case test2.php. The directives in .htaccess were applied to the file however the includes were not found in the current folder (test2). At this point PHP does not give up hence it looks in any include paths for the files. It still cannot find the files, gives up, and produces the error message. I have laboured this a little to make a point in most cases the answer lies in the error message this is crying out for an include path to fix the problem. The final .htaacess file looks like this: php_value include_path ".;/www/atest" php_value auto_prepend_file "top.php" php_value auto_append_file "bottom.php" The include path points to the folder that contains the pages to be included. Net result of adding the above line is that any php file within the folder containing .htaccess and sub-folder files will have top.php and bottom.php automatically included. All the best

This is the very reason why I wrote how to downgrade MySQL. A friend’s service provider only offers MySQL 4 and probably wont upgrade to version five for some time. It was becoming a pain to continually correct tables before unloading. The solution was to match his service provider’s installation hence the downgrade. My personal advice would be to downgrade just makes life easier. I have two versions of UniServer running either MySQL4 or MySQL5 and use the appropriate one. If you are running your own servers use MYSQL5. If you wish to downgrade check out this page on UniCenter: http://center.uniformserver.com/uniserver/..._to_mysql4.html There is no right or wrong answer use what ever meets your needs.

Sorry I just did not have time to include the code. I may have missed some lines however here is the full code for it.php that worked for me: Note: Located in W:\home\admin\www\includes\lang\ Note: The escape chatacter is \

You need to open the file it.php and escape the single quote. This will push the problem further down the page hence you need to change the following lines: 75 E\' 80 C\' 107 E\' 129 un\' 148 l\' 170 l\' 206 all\' 207 un\' That worked not sure if they are the right quotes.

You can find the language files here: http://phpmyadmin.cvs.sourceforge.net/phpm...ng/?sortby=file

Internal password: The MySQL password 67457e226a1a15bd contained in the table user is not the external password. When privileges were set for user root the password was entered in as text “root” MySQL converted this into that long number for internal use. External password: From PHP $dbuser = 'root' is sent to your MySQL database where it is converted into a number and matched against the internal number (67457e226a1a15bd). Access is allowed because the numbers match. From PHP if $dbuser = '67457e226a1a15bd' this number (text) is sent to MySQL converted into a number that will not match against the internal number for root. Access is denied because the numbers do not match. Online: When you are on line MySQL listens for any requests and accepts any with user=root and password=root these are the default settings. To prevent external access to root you need to change the root password in MySQL. Run apanel: http://localhost/apanel/ Click on: phpMyAdmin Click on: Privileges To the right of root click on Edit privileges Scroll down to: Change password Tick the radio button: Password Enter your password Enter your password again Click on Go. Doing this will also prevent access using apanel. You need to change the password contained in the file mysql_password Located in folder: \diskw\home\admin\www To match the one you set in MySQL privileges.

If you can connect using apanel you have no problem! UniServer 3,3 Defaults name=root password=root example code: MySQL Test MySQL test <?php mysql_connect("localhost", "root", "root"); if (mysql_select_db("phpmyadmin")){ echo "CAN connect to database"; } else{ echo "CAN NOT connect to database"; } ?> Hope that helps

"I am in the process of writing a guide purely to cover this situation using UniServer. " Finished can be found here: http://www.center.uniformserver.com/

I have seen this problem raised on a number of forums what you are looking for is an SMPT server. I assume you are either learning PHP or want to test your programs locally. I am in the process of writing a guide purely to cover this situation using UniServer. This will be out in about a week or two. However if you need the info more quickly and have the experience take a look at this page http://www.burrotech.com/om_steps5.php . They have produced an ideal solution to this problem and for free. To run something like this: <?php $mailaddress = "admin1@fred.com"; $mailsubject = "Another test"; $mailbody = "Hello, world! Again"; mail($mailaddress, $mailsubject, $mailbody); ?> From a clean install of Office Mail. Leave all the defaults as they are and perform the next two steps: 1) Click Users: Set up a user named admin1 password admin1 2) Click on local distribution and + (add) enter: Mail address: admin1@fred.com To user enter: admin1 Thats all you need to do, run your PHP program and the mail will be received in Office Mail. Check it out if Office-Mail not displayed click its icon bottom right in the system tray. All the best

Not sure if I am allowed but this site may help with a little more detail. http://www.center.uniformserver.com/ The link may change?

Not sure if this link will help: http://phpmyadmin.cvs.sourceforge.net/phpm...ng/?sortby=file

I could not resist the temptation of taking a more detailed look at Joomla I downloaded and installed it. It is a CMS designed to ease site construction administered remotely. Had no problems installing it on US 3.3 a quick check confirms it sets up a configuration file configuration.php (it does not use a table in the MySQL database). Within Joomla, changing site global configurations will overwrite settings in this file if you make changes locally you must change the settings in the remote configuration file. (You cannot just upload the file because you will loose the remote system setting). When transferring a site you need to keep track of what changes are made it is not just a matter of uploading the database but also any folders and whatever other material changes external to the database. Take a simple example adding a new image folder and images. Within Joomla create the new folder and upload (locally) the images. Joomla creates references in its database. When you transfer your site, upload the database then create the image folder and upload the images into it (make sure the folder has the correct CHMOD values set). It would be wise to download the configuration file from your remote site and save it. Just saves time if you ever accidentally overwrite it just a matter of uploading to get your site working. I see no major problems in doing what you want give it a few dry runs until you get a methodology that works you. In theory you can upload the database and all the Joomla files (including your new ones) finally upload your saved remote configuration file. It will work however the pain will come when you need to change the CHMOD values on certain files in addition when your site expands the size will make the upload time impossible. Hence track the changes a just upload these.

I assume you are not using US as your live server and that you are using a service provider. You will need to install Joomla first allowing it to pick up various system parameters during set-up. Create a few test pages to make sure it works. I would reverse the question can you now transfer from a live server to US. The reason for this is to highlight incompatibility problems. The first that springs to mind is MySQL. I am not conversant with Joomla but the next problem is where are the set-up system parameters stored (table or file) if these are over written when transferring from one system to another them you will have problems. Take a look at the Joomla manual installation process may give you some pointers. Hope this points you in the right direction.

I am sure if you supply a little more detail someone will help. Do you have any error messages? Is Apache server running? Are you using drive W or another drive letter ?

A) and htaccess should read htpasswd the paths are: W:/htpasswd /home/admin/www/htpasswd W:/htpasswd /www/htpasswd C) MySQL is a two-part process: 1) From apanel click on Run Msql (starts the server) 2) From apanel click on phpMyAdmin 3) In phpMyAdmin click on Privileges (third link from bottom) 4) To the right of user root click on Edit Privileges 5) Scroll down the page to Change Password 6) Click the radio button to the left of Password 6) In the password window ener your new password 7) Below this Re-type your new password 8) Click on Go (That completes the first step) Using windows explorer navigate to the file named mysql_password Full path shown below: ??/Uni Server/diskw/ home/admin/www/mysql_password OR from drive W: W:/home/admin/www/mysql_password Edit this file in a text editor delete the old password and add your new one.

I found this on Whitsoft Development: “SECURITY ALERT: SlimFTPd 3.15 through 3.17 have buffer overflow vulnerabilities that could potentially lead to remote code execution. Users are advised to upgrade to SlimFTPd 3.18 immediately!” 1) My question; is it safe to use the current (3.16) plug in download. Added to the security issue the new version 3.18 requires: “Attention: SlimFTPd now requires the Visual C++ 2005 runtime library Download Visual C++ 2005 Runtime Redistributable Package (2.52 MB)” 2) Will you be up grading to version 3.18 if so how will this impact on portability (run time library issue). This does not cause me a problem, I do not use this plug in, however I would not like it to impact on either security or portablity of US, US is a great product because of its perceived simplicity (hides the real complexity).

I think to many questions in one post and not enough detail. Sorry to be negative well I hate negative so here goes. To start you on the correct path, take one clean hard disk named D: 1) Copy all the folders and their content contained in diskw onto your D drive. 2) From folder Uniform ServerNow copy : Server_Start.bat Stop.bat Disk Start.vbs Into the top level of D 2) Open Stop.bat and change the path as show: REM was this diskw\home\admin\program\pskill.exe Apache.exe c becomes home\admin\program\pskill.exe Apache.exe c All other lines remain unchanged 3) Open Server_Start.bat and change these lines: REM was this diskw\home\admin\program\pskill.exe Apache.exe becomes home\admin\program\pskill.exe Apache.exe IF NOT ERRORLEVEL 1 goto started REM line not required set Disk=%1 REM line not required IF "%Disk%"=="" set Disk=w Rem you do not need to create a disk rem create the disk Rem like I said you do not need this subst %Disk%: "diskw" REM this is redundant IF ERRORLEVEL 1 goto hint REM new line this sets the env to disk drive d: set Disk=d The rest of the code can remain unchanged or you can clean it up. Look at my other post regarding recursive loop. Need to make this mod. You can now start and stop your servers using these two batch files. No time to look at the VB file but that similar. 4) "Also i need a sendmail script to be added into the server, i found a simple one but dont know how to intergrate it all" Not sure if your comment is correct regarding a mailer for Apache you are probably looking for a PHP mailer object. 5) "also i need all these fiels to start up at system start, as a background process. so as soon as ANYONE loggs onto the computer apache, php, mysql and sendmail is running." You are asking "can these be run as service" yes you can. I have never done it there fore can offer no advice on this. 6) "I also need to setup CronJobs.. i dont know what software i need for this if " I have a problem with this question. On one hand, it looks as if you are using Windows and then you ask a UNIX question. Take each problem one step at a time resolve it and then move onto the next.

-- This script converts any old privilege tables to privilege tables suitable -- for MySQL 4.0. -- You can safely ignore all 'Duplicate column' and 'Unknown column' errors" -- because these just mean that your tables are already up to date. -- This script is safe to run even if your tables are already up to date! -- On unix, you should use the mysql_fix_privilege_tables script to execute -- this sql script. -- On windows you should do 'mysql --force mysql -- Convert all tables to UTF-8 with binary collation -- and reset all char columns to correct width ALTER TABLE user MODIFY Host char(60) NOT NULL default '', MODIFY User char(16) NOT NULL default '', MODIFY Password char(41) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE db MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', MODIFY User char(16) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE host MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE func ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE columns_priv MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', MODIFY User char(16) NOT NULL default '', MODIFY Table_name char(64) NOT NULL default '', MODIFY Column_name char(64) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE tables_priv MODIFY Host char(60) NOT NULL default '', MODIFY Db char(64) NOT NULL default '', MODIFY User char(16) NOT NULL default '', MODIFY Table_name char(64) NOT NULL default '', MODIFY Grantor char(77) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE user add File_priv enum('N','Y') NOT NULL; CREATE TABLE IF NOT EXISTS func ( name char(64) binary DEFAULT '' NOT NULL, ret tinyint(1) DEFAULT '0' NOT NULL, dl char(128) DEFAULT '' NOT NULL, type enum ('function','aggregate') NOT NULL, PRIMARY KEY (name) ) CHARACTER SET utf8 COLLATE utf8_bin; -- Detect whether or not we had the Grant_priv column SET @hadGrantPriv:=0; SELECT @hadGrantPriv:=1 FROM user WHERE Grant_priv LIKE '%'; ALTER TABLE user add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL; ALTER TABLE host add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL; ALTER TABLE db add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL; --- Fix privileges for old tables UPDATE user SET Grant_priv=File_priv,References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0; UPDATE db SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0; UPDATE host SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0; -- -- The second alter changes ssl_type to new 4.0.2 format -- Adding columns needed by GRANT .. REQUIRE (openssl)" ALTER TABLE user ADD ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL, ADD ssl_cipher BLOB NOT NULL, ADD x509_issuer BLOB NOT NULL, ADD x509_subject BLOB NOT NULL; ALTER TABLE user MODIFY ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL; -- -- Create tables_priv and columns_priv if they don't exists -- CREATE TABLE IF NOT EXISTS tables_priv ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL, Grantor char(77) DEFAULT '' NOT NULL, Timestamp timestamp(14), Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL, Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name) ) CHARACTER SET utf8 COLLATE utf8_bin; CREATE TABLE IF NOT EXISTS columns_priv ( Host char(60) DEFAULT '' NOT NULL, Db char(60) DEFAULT '' NOT NULL, User char(16) DEFAULT '' NOT NULL, Table_name char(60) DEFAULT '' NOT NULL, Column_name char(59) DEFAULT '' NOT NULL, Timestamp timestamp(14), Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name,Column_name) ) CHARACTER SET utf8 COLLATE utf8_bin; -- -- Name change of Type -> Column_priv from MySQL 3.22.12 -- ALTER TABLE columns_priv change Type Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL; -- -- Add the new 'type' column to the func table. -- ALTER TABLE func add type enum ('function','aggregate') NOT NULL; -- -- Change the user,db and host tables to MySQL 4.0 format -- # Detect whether we had Show_db_priv SET @hadShowDbPriv:=0; SELECT @hadShowDbPriv:=1 FROM user WHERE Show_db_priv LIKE '%'; ALTER TABLE user ADD Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Alter_priv, ADD Super_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Show_db_priv, ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Super_priv, ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Create_tmp_table_priv, ADD Execute_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Lock_tables_priv, ADD Repl_slave_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Execute_priv, ADD Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Repl_slave_priv; -- Convert privileges so that users have similar privileges as before UPDATE user SET Show_db_priv= Select_priv, Super_priv=Process_priv, Execute_priv=Process_priv, Create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=file_priv, Repl_client_priv=File_priv where user"" AND @hadShowDbPriv = 0; -- Add fields that can be used to limit number of questions and connections -- for some users. ALTER TABLE user ADD max_questions int(11) NOT NULL AFTER x509_subject, ADD max_updates int(11) unsigned NOT NULL AFTER max_questions, ADD max_connections int(11) unsigned NOT NULL AFTER max_updates; -- -- Add Create_tmp_table_priv and Lock_tables_priv to db and host -- ALTER TABLE db ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL, ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL; ALTER TABLE host ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL, ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL; alter table db change Db Db char(64) binary DEFAULT '' NOT NULL; alter table host change Db Db char(64) binary DEFAULT '' NOT NULL; alter table user change max_questions max_questions int(11) unsigned DEFAULT 0 NOT NULL; alter table tables_priv change Db Db char(64) binary DEFAULT '' NOT NULL, change Host Host char(60) binary DEFAULT '' NOT NULL, change User User char(16) binary DEFAULT '' NOT NULL, change Table_name Table_name char(64) binary DEFAULT '' NOT NULL; alter table tables_priv add KEY Grantor (Grantor); alter table columns_priv change Db Db char(64) binary DEFAULT '' NOT NULL, change Host Host char(60) binary DEFAULT '' NOT NULL, change User User char(16) binary DEFAULT '' NOT NULL, change Table_name Table_name char(64) binary DEFAULT '' NOT NULL, change Column_name Column_name char(64) binary DEFAULT '' NOT NULL; alter table db comment='Database privileges'; alter table host comment='Host privileges; Merged with database privileges'; alter table user comment='Users and global privileges'; alter table func comment='User defined functions'; alter table tables_priv comment='Table privileges'; alter table columns_priv comment='Column privileges'; # # Create some possible missing tables # CREATE TABLE IF NOT EXISTS help_topic ( help_topic_id int unsigned not null, name varchar(64) not null, help_category_id smallint unsigned not null, description text not null, example text not null, url varchar(128) not null, primary key (help_topic_id), unique index (name) ) CHARACTER SET utf8 comment='help topics'; CREATE TABLE IF NOT EXISTS help_category ( help_category_id smallint unsigned not null, name varchar(64) not null, parent_category_id smallint unsigned null, url varchar(128) not null, primary key (help_category_id), unique index (name) ) CHARACTER SET utf8 comment='help categories'; CREATE TABLE IF NOT EXISTS help_relation ( help_topic_id int unsigned not null references help_topic, help_keyword_id int unsigned not null references help_keyword, primary key (help_keyword_id, help_topic_id) ) CHARACTER SET utf8 comment='keyword-topic relation'; CREATE TABLE IF NOT EXISTS help_keyword ( help_keyword_id int unsigned not null, name varchar(64) not null, primary key (help_keyword_id), unique index (name) ) CHARACTER SET utf8 comment='help keywords'; # # Create missing time zone related tables # CREATE TABLE IF NOT EXISTS time_zone_name ( Name char(64) NOT NULL, Time_zone_id int unsigned NOT NULL, PRIMARY KEY Name (Name) ) CHARACTER SET utf8 comment='Time zone names'; CREATE TABLE IF NOT EXISTS time_zone ( Time_zone_id int unsigned NOT NULL auto_increment, Use_leap_seconds enum('Y','N') DEFAULT 'N' NOT NULL, PRIMARY KEY TzId (Time_zone_id) ) CHARACTER SET utf8 comment='Time zones'; CREATE TABLE IF NOT EXISTS time_zone_transition ( Time_zone_id int unsigned NOT NULL, Transition_time bigint signed NOT NULL, Transition_type_id int unsigned NOT NULL, PRIMARY KEY TzIdTranTime (Time_zone_id, Transition_time) ) CHARACTER SET utf8 comment='Time zone transitions'; CREATE TABLE IF NOT EXISTS time_zone_transition_type ( Time_zone_id int unsigned NOT NULL, Transition_type_id int unsigned NOT NULL, Offset int signed DEFAULT 0 NOT NULL, Is_DST tinyint unsigned DEFAULT 0 NOT NULL, Abbreviation char(8) DEFAULT '' NOT NULL, PRIMARY KEY TzIdTrTId (Time_zone_id, Transition_type_id) ) CHARACTER SET utf8 comment='Time zone transition types'; CREATE TABLE IF NOT EXISTS time_zone_leap_second ( Transition_time bigint signed NOT NULL, Correction int signed NOT NULL, PRIMARY KEY TranTime (Transition_time) ) CHARACTER SET utf8 comment='Leap seconds information for time zones';

I have mentioned the incompatibility between MySQL 4 and 5 this shows you how to downgrade UniServer 3.3 from MySQL 5 to MySQL 4. The process is relatively simple. 1) You need to work on clean copies of UniServer 3.2a and 3.3 download these and save both files into the same folder. 2) Unzip both files (no need to specify a folder) into the current folder. 3) Within UniServer3_3 rename database folder mysql we need this later. Rename this folder: UniServer3_3/ Uniform Server /diskw/user/local/mysql To: UniServer3_3/ Uniform Server /diskw/user/local/mysql_old 4) From UniServer3_2a copy the mysql folder and all its content to UniServer3_3: Copy this folder: UniServer3_2a/ UniServer3_2a /diskw/user/local/mysql To: UniServer3_3/ Uniform Server /diskw/user/local/mysql That completes the database installation. MySQL 4 database contains tables for the old phpMyAdmin package these need updating to the new version of phpMyAdmin. Just a matter of deleting the old and replace with the new. 5) Delete the old phpMyAdmin folder UniServer3_3/Uniform Server/diskw/user/local/mysql/data/phpMyAdmin 6) Copy new phpMyAdmin contained in mysql_old/data into mysql/data Copy folder: UniServer3_3/Uniform Server/diskw/user/local/mysql_old/data/phpMyAdmin To: UniServer3_3/Uniform Server/diskw/user/local/mysql/data 7) Delete folder mysql_old that's it run the server and check it out. You can run with this however if you look in the MySQL error log file UniServer3_3/Uniform Server/diskw/user/local/mysql/data/{your name}.err You will find two warning messages similar to this: 060504 21:17:40 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run 060504 21:17:40 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them They are only warning messages and can be safely ignored unless your programmes use these extra facilities. To resolve the above follow these instructions 8) (see note 1) Obtain a file named: mysql_fix_privilege_tables.sql 9) Save this file in the following folder: UniServer3_3/Uniform Server/diskw/user/local/mysql/bin 10) (see note 2) Open NotePad (or any other text editor) copy and past these two lines into it mysql -u root -p mysql --force pause Save the file as fix_tables.bat it can be named what you like make sure you use .bat and not .txt. Save or move the file to the following folder: UniServer3_3/Uniform Server/diskw/user/local/mysql/bin 11) Start your server and start MySQL 12) Navigate to the batch file fix_tables.bat (using Windows Explorer) run it (double clicking on it name or icon). When requested for a password type in root The batch file will run and update your database. You can safely ignore the errors these are expected (some of the tables exist hence duplication errors are reported and that's whey you cannot use phpMyAdmin and need to use a command line) 13) All that remains is to shutdown and restart the servers. Check the error log and test your programs. Note 1: How to obtain the file mysql_fix_privilege_tables.sql a) You can download it from??? I tried in vain to find a site (sorry). Ask the UniServer development team for it (well they removed it to save space) c) I must confess the one I used came from a WAMP5 installation. d) Its only a text file see my reply!!!! Copy and save it using note pad. Note 2: Breakdown of command line mysql --- Database program -u --- user name -p --- password (none given forces you to enter one) mysql --- data base name --force --- continue even if we get sql errors pause - it allows you to see what happed (forces you to press any key) My personal reason for downgrading I had Zen Cart running on 3.2a with no problems. However, 3.3 refused to play ball because of MySQL 5 after performing the above mod it now works fine. I like 3.3 with the extra bells and whistles.