Jump to content

TweezerMan

Members
  • Posts

    1,763
  • Joined

  • Last visited

Everything posted by TweezerMan

  1. Without knowing the exact details about what you've set up on your site, the path you have is generally correct, unless you're getting a specific error about not being able to find the file. Depending on how your CSV file is being uploaded to your site, I'd first suspect the 'LINES TERMINATED BY'. On a Windows machine, '\r\n' would be correct, but on a Linux server, it normally would be just '\n'. If your file is uploaded via FTP in ASCII mode, the '\r\n' line endings are automatically converted to '\n'. Assuming this is the case, no data would ever be imported, as the MySQL server never finds a "\r\n" character combination to mark the end of the first line. If this sounds likely, you'd need to change the 'LINES TERMINATED BY' to look for just '\n' rather than '\r\n': >LINES TERMINATED BY '\\n'
  2. Welcome to the forums, doesitwork!
  3. Welcome to the forums, kaarthik!
  4. Welcome to the forums, Dee! From what I can tell, the TCH servers would only have the base installation files for PEAR - no packages (libraries). Yes, but your include directory should come before the TCH server directories so any package you upload will take precedence if that same package happens to be installed on the server: >php_value include_path ".:/home/myaccount/public_html/ih/inc:/usr/lib/php:/usr/local/lib/php" You don't have to upload "all of the PEAR files", but you do need to upload any PEAR packages that are needed. It sounds like you downloaded the SOAP package and installed it on your server in your include directory. When the SOAP-0.9.1.tgz file is unpacked, the files are extracted into a directory named 'soap-0.9.1'. This directory must be renamed to 'SOAP' in your include directory in order for your scripts to find the 'SOAP' package files (such as SOAP/Client.php). The SOAP package also requires 3 additonal PEAR packages to be downloaded and installed: HTTP_Request Net_URL Net_Socket 1) When the HTTP_Request package is unpacked, the files are extracted into a directory named "HTTP_Request-1.2.4". This directory must be renamed to 'HTTP' in your include directory in order for your script to find the 'HTTP' package files. 2) When the Net_URL package is unpacked, the files are extracted into a directory named "Net_URL-1.0.14". This directory must be renamed to 'Net' in your include directory in order for your script to find the 'Net' package files. 3) When the Net_Socket package is unpacked, there is one file that is extracted into a directory named "Net_Socket-1.0.6". You'll already have a directory named 'Net' from step 2 above, so you just need to move/upload the Socket.php file into the 'Net' directory in your include directory on the server. If you installed your own PEAR package installer on your server account, and used it to download and install the above PEAR packages, the installer would automatically handle the directory renaming in the steps above for you. Your include directory should end up with these subdirectories: >/home/myaccount/public_html/ih/inc |--HTTP |--Net |--SOAP Once you have the 4 PEAR libraries installed as I've described above, your soap_01.php test script works fine. It doesn't output anything (because there's no code that produces any output), but it doesn't generate any errors either. Hope this helps...
  5. I don't think you'd need a complicated script, but I think you'd need one. If I understand correctly what you're doing, the script would need to log in and connect to your database, then execute a 'LOAD DATA INFILE' query to import your CSV file. It's not using phpMyAdmin to do the job, but it's doing the same task in the same way that phpMyAdmin does.
  6. Welcome to the forums, Bam!
  7. TweezerMan

    Seo

    They called me at home a few days ago, saying that they help sites get high placement on all the major search engines and "would I be interested in that?" I told the lady that I was in the top 5 or 10 already for the terms 'tweezer' and 'tweezerman' - she asked, "Really?" I said yes, and she asked me, "On all the major search engines? Google? MSN? Yahoo?". I said, "Yes", and she said she'd have to check that out and hung up. I wish I had remembered some of the squirrely things that I've got high ranking for to tell that lady, such as 'scott peterson mail'. As it was, I was *not* impressed with anyone cold-calling me at home offering me SEO that I don't need or want. Even if I wanted someone to help me with SEO, there's no way I'd hire someone I'd never heard of before that cold-called me at home. Reminds me too much of door-to-door salesman (I don't buy anything from them either).
  8. There some documentation with links at the WordPress Codex on how to import Blogger posts into WordPress.
  9. Welcome to the forums, Karim!
  10. Welcome aboard, Kevin!
  11. Welcome to the forums, brockc!
  12. Welcome to the forums, webcarl!
  13. I think that would depend on how you are "manually" importing the data.
  14. You can't block the spam by configuring a filter to block "?" characters. These e-mails contain characters from another character set which don't have an equivalent character in the character set you're using on your machine. Your browser / e-mail program automatically displays these characters that don't have equivalents as "?" characters, but the characters in the original e-mail are unchanged. An e-mail filter would see the actual characters in the e-mail, not the"?" characters that you see. I don't know if this is even possible in SpamAssassin, but I think what you'd need here is a filter that would block based on the character set of the message.
  15. I think it would depend on the queries you're trying to set up. You might take a look at "Rewriting Subqueries as Joins for Earlier MySQL Versions" in the MySQL manual and see if there's anything there that might help you out.
  16. Welcome to the forums, Henrik! Using setlocale('LC_TIME','swedish'); localizes output only of the strftime() function, not the date() function. In order to localize your dates, you'd need to alter the entry_time() function to something like this: >function entry_time($format='%B %e, %Y %H:%M') { global $entry; setlocale(LC_TIME,'swedish'); echo strftime($format, strtotime($entry['date'])+3600*6); } Then you could use code like the following: >Skrivet av <strong><?php entry_smart_name(); ?></strong> den <?php entry_time('%e %B, %Y'); ?> klockan <?php entry_time('%H:%M'); ?> ...which should produce the following output: That's about as close as I could make it to what you want without a significant amount of programming. Hope this helps...
  17. Welcome to the forums, ets960!
  18. From what I understand, MySQL 4.1 is also a "production release", but there are some significant differences between 4.0 and 4.1 that would cause a lot of scripts to break if MySQL was upgraded to 4.1 without warning.
  19. Welcome to the forums, Fenn!
  20. Thanks for the update. Evidently, whatever process changed the straight quotes to curly quotes also changed the '--' regular dashes to en dashes (probably due to editing in MS-Word). I've corrected this in the original post as well.
  21. The 1.6.2 version of GD would explain why you don't have GIF support. This is from the 'Image Functions' section of the PHP manual: I suspect the older version of GD may explain the other issues you were having when you removed the check for 'imagecreatefromgif'.
  22. You need to prepend your CPanel username plus a "_" to your database name and database user name: >Database Username: queenpi_queenpic Database Name: queenpi_LinkTracking
  23. Welcome to the forums, Darren!
  24. Although you can access the forums from forums.totalchoicehosting.com, most (if not all) of the internal links use www.totalchoicehosting.com/forums. These are different domains as far as cookies are concerned, so if you're going to whitelist a domain, I'd suggest whitelisting www.totalchoicehosting.com, and access the forums in your browser via www.totalchoicehosting.com/forums/.
  25. I don't use SpamAssassin (no e-mail accounts) and have never run this script, so I don't know what kind of output you should be seeing, but yes, I think you ought to be seeing more than what you're getting. The only thing I can figure is that an error is occurring with the commands in backquotes, but the error message is not being sent to the browser. I'd suggest adding '2>&1' to the end of each of the backquoted commands, so any error messages should be displayed in your browser as well: >print `$salearn -p /home/tchaccount/.spamassassin/user_prefs –mbox –spam –showdots /home/tchaccount/mail/myspam 2>&1`; >print `$salearn -p /home/tchaccount/.spamassassin/user_prefs –mbox –ham –showdots /home/tchaccount/mail/myham 2>&1`; If this works for you, I'll add it to the script code in TCH-Bruce's post above.
×
×
  • Create New...