pauper_i

XMB has an install script which will create the tables for you ... you have to give it a username and password for your database and it does the rest. Just make sure you read the instructions properly and don\'t try taking any shortcuts. D

Did you update the directory index: ?

Take a look at Trio Of Trouble - In Windows by Liam Getreu - it walks you through the configuration step by step for windows!

DROP TABLE address_book; DROP TABLE address_format; DROP TABLE banners; DROP TABLE banners_history; DROP TABLE categories; DROP TABLE categories_description; DROP TABLE configuration; DROP TABLE configuration_group; DROP TABLE counter; DROP TABLE counter_history; DROP TABLE countries; DROP TABLE currencies; DROP TABLE customers; DROP TABLE customers_basket; DROP TABLE customers_basket_attributes; DROP TABLE customers_info; DROP TABLE geo_zones; DROP TABLE languages; DROP TABLE manufacturers; DROP TABLE manufacturers_info; DROP TABLE newsletters; DROP TABLE orders; DROP TABLE orders_products; DROP TABLE orders_products_attributes; DROP TABLE orders_products_download; DROP TABLE orders_status; DROP TABLE orders_status_history; DROP TABLE orders_total; DROP TABLE products; DROP TABLE products_attributes; DROP TABLE products_attributes_download; DROP TABLE products_description; DROP TABLE products_notifications; DROP TABLE products_options; DROP TABLE products_options_values; DROP TABLE products_options_values_to_products_options; DROP TABLE products_to_categories; DROP TABLE reviews; DROP TABLE reviews_description; DROP TABLE sessions; DROP TABLE specials; DROP TABLE tax_class; DROP TABLE tax_rates; DROP TABLE whos_online; DROP TABLE zones; DROP TABLE zones_to_geo_zones; Just a simple parse from the information you provided.

Take a look at the DATE_ADD(date,INTERVAL expr type) and DATE_SUB(date,INTERVAL expr type) functions: http://www.mysql.com/doc/en/Date_and_time_..._functions.html

Hi Nick! Not wishing to pour gasoline on your personal hell, but just an observation: If you had picked up a MySQL book on the day you posted in the first of those forums you could have answered your own question by now. 11 days later, and you are still looking for someone else to answer the questions for you! The biggest problem you are facing is that you are providing too much information of the wrong type, and not enough of the right type: Don\'t bother explaining about the sybase crossover - a lot of MySQL programmers will see that and skip to the next question. Get it working in MySQL then worry about the changeover afterwards. You are apparently trying to synch up two tables: please define what you mean by \'synch up\' - same info in both? Replicate any changes in one to the other??? Why? Why not just store the changes one time and access that info from both tables? If this is a replicated table, then why is the data structure different? I\'m sorry, but there are too many questions left open, it would take a book to write out all the possible answers. Please sit down and rethink your problem, see if you can define it for us as simply as possible, outlining the information we need. It would appear that the basic fundamental issue here is database design - I realise that having had this dumped in your lap this is probably not a good time to adddress this, but it would probably be easier to get the databases redesigned now than to fudge around the issues and have to cross many more bridges further down the road. Hope that helps! D

Crossposted: http://www.phpfreaks.com/forums/topic9906.php Please don\'t crosspost. It only means we have to read, and often research the same question multiple times when we could be spending our time on another question or maybe even with our families! Thanks!

http://www.phpfreaks.com/phpref/2.php How many concurrent queries are you running?

Hi Jointy, I\'m assuming you can probably read English so I\'ll keep it in this language so that others can check my answer: From what I can understand with my very rusty German, you are not getting the same results from MySQL as you do from PHP with the MD5 checksum. Looking at your code, however, you are using a double checksum and I think that that is where you may be hitting the problem. Try removing the SHA1 functions, leaving only the MD5 functions and it may cure your problem! The SHA1 version is based on a different RFC from the MD5 version, although the two are fairly similar in their operation, the difference being the algorithm used where the MD5 version operates on 448 bits while the SHA1 version operates on 512 bits. You can read the RFCs for MD5 - RFC1321 and SHA-1 - RFC3174 for full details. (Is the SHA1 capability included in versions of both MySQL and PHP exported outside the US?) Basically, you are calculating a checksum of the password, then creating a checksum of the checksum. I don\'t know whether you took this step in your original checksum of the database stored version, but one or the other is fine, you don\'t normally need both. Could we see the code used to create the field \'MD5 AS hash\'?

There are many pro\'s and con\'s for Dreamweaver. Its a complete package and, if you are prepared to use it correctly, it will do a lot for you. On the other hand, there\'s a lot to be said for hand coding too! You will probably find that most of the people on this forum use different editors, and most use more than one. Lets look at your problem and attack it from there: Your data is currently in Access and you want to port it over to MySQL. You don\'t mention what the current front end is: ASP or VBA Access - it does make a difference! If your current front end is in ASP, there are tools available that will convert your ASP into (sort of) PHP. There will still be some tweaking to do, but it will save you a lot of time. If on the other hand the code is in VBA Access, then I\'d suggest you sit down with a stack of blank paper and start writing your requirements since you are going to have to recode it from the ground up. In the former case (ASP), you could probably use notepad, but I\'d lean more towards a good editor such as HTMLKit (www.chami.com). In the latter case, you should probably go with dreamweaver since it will help to maintain continuity between the pages. The final choice is yours to make - there are many posts in this forum comparing the worths of different editors, take a browse through and you will find 400 different opinions! Good luck! D

Not wishing to be the bearer of bad news but ... Your present path includes spaces. Since Apache is really *nix code that has been tweaked to run on windows, it has a whole different idea as to how spaces should appear in a directory listing. Alternatives: * Reinstall apache to a different folder without spaces - pain in the butt, but pays off in the long run. * change your paths to reflect the 8.3 names - easy quick fix, but now you have to do this for every script from now until forever! Using the 8.3 syntax. your path would look something like: C:/Progra~1/Apache~1/Apache2/bin/password.exe You might want to use the DIR command with the /X parameter to get the long and short directory names so you can verify the actual number used after the tilde. Hope that resolves your problem! D

http://www.google.com/search?hl=en&ie=UTF-...lpdesk+software

If you\'ve installed mysql then you will need to configure that too. Part of the configuration is to provide a username and password for access to it. Do you need the mysql part? D

No guarantees on this one, but it may help. Since you are in an intranet environment, grab a copy of the Internet Explorer Administration Kit (IEAK) 6 SP1 and redeploy IE to your users with customised settings. This should allow you to turn the darn bug OFF before you roll it out. Just an idea - overkill perhaps, but I assume you\'re using some form of centralised software deployment so it shouldn\'t be a major problem to do. D

OK, lets start at the bottom and work upwards: Configuring Apache to work on your machine - Take a look at the tutorials, scroll to the bottom of the page and select the one that is appropriate for your OS and it will explain how to configure it. Drag and drop uploads can be done but need a bit of coding to set them up - you might consider using an FTP server on your machine also, you can open a browser to that and drag and drop will work right out of the box. Displaying the contents of a directory is simple enough ... The setup of the httpd.conf (the apache configuration file) defines which files go active if someone browses to a directory. On my test server I have index.html set up so if that file exists it will open automatically. On folders where I want to be able to browse directories, I simply rename the index file to index.htm - it will still work but no longer opens automatically so I can browse the directory. One thing you haven\'t mentioned in all this is security. Please bear in mind that these steps will leave the machine wide open to abuse from internet, so you need to consider at least password protection to prevent this (assuming that the machine is open to internet of course!) Hope that helps! D