EvanAgee

Thanks Gizmola! I'm curious, since there isn't a well-known (or suggested) method for dealing with this case, is there a better workflow that I haven't yet considered? I know it's possible to have 2 different projects, but I figured there had to be some way to connect the projects together and share updates between them. I'll have to research the svn sandboxes idea. Thanks much!

Greetings All, I'm new to subversion, but I have it setup on my web server (MediaTemple.net) and I've been able to successfully create a repository, etc. My question is more about workflow. So the situation is quite common, I have www.mywebsite.com that's the live/production version of my project and I have beta.mywebsite.com which is a test/development version of the same site. About 99% of the code base is the same for both sites but they're are some configuration variables that are different to keep them from interfering with each other. My goal workflow is this: 1. Make an update on my local machine, commit those changes to beta... 2. Preview those changes on beta to make sure all is well 3. Pull (or update) those changes into www once I've verified that everything is good to go. Could anyone give me a little help with how I would set this up? I'm not sure why it has been so confusing to this point.

Hello all, I'm trying to zip up a large site, about 20GB and download the zip file to my local machine. I've managed to get the zip file created on the server and then download the file, however when I try to unzip the file on my Mac via the terminal I get the following message: End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and zipfile comment will be found on the last disk(s) of this archive. unzip: cannot find zipfile directory in one of httpdocs.zip or httpdocs.zip.zip, and cannot find httpdocs.zip.ZIP, period. The server is a MediaTemple Nitro server. Any clues what's going on?

Great, thanks for the assistance!

Hey all! I've got an RSS feed that I'm generating using a Smarty template. The feed is being generated just fine, but Google Reader (and probably other RSS aggregators) aren't picking up on the feed <title> attribute correctly. Instead they're using the <title> from the first <item> in the feed as the title. Below is the feed URL. Any help would be great appreciated. http://www.memoryupgrade.pro/blog/feed.rss

So I've got a content management system that stores page content/data in one table and assets (images, videos, etc) in a separate table. I know I can use a JOIN to get all of the data with one query, but I'm looking to match the resulting output with the PHP array I'm currently using to distribute the resulting content to the Smarty template. Currently I get all of the page data and set that array to $page. Then I do a second query to get all of the assets and set that resulting array to $page["assets"]. So, I'm wondering if there's a good way to take my new JOIN query and structure that result so rather than having one large 1 dimensional array I have an array that's setup with all of the results from the assets table as an element of the content table result array. Hope I'm making sense

It ended up being a problem with register_long_arrays in php.ini. It was ignoring the array completely! I can't see how that would ever be useful to anyone, limiting array size. Changed, and problem fixed.

So this is my php: $sql = "INSERT INTO $content_table (".implode(", ",array_keys($cFields)).", timestamp) values (".implode(", ",array_values($cFields)).", now())"; For whatever reason I'm getting this error: An error occured when we tried to create the page. Please contact your system administrator. Here is the error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' timestamp) values (, now())' at line 1 Statement executed was: INSERT INTO tiger2_content (, timestamp) values (, now()) HOWEVER, this worked fine under PHP4. Ideas? $cFields is obviously an array that I'm constructing dynamically using $_POST variable values. Any help much appreciated!

SOLVED Just had to add: RewriteCond %{REQUEST_URI} !^/index.php after RewriteCond %{REQUEST_URI} !^/admin/ Thanks everyone, now I can go into Monday with a clean slate and ready to work!

I get a "RewriteLog not allowed here " error when I try to place the log file in the same direcotry as my error_log, etc files are.

No I haven't, do you know of a particularly good tutorial to get me started?

Originally I was getting a 500 error because my php file that controls all of the various URLs is index.php, so I was getting a too many redirects error. I fixed that problem and now I'm just getting a 404 error. Again, this was working fine on my last server with the same host.

But it does end in / which is also part of that regexp.

This one worked on my old server: RewriteRule ^(.+)(\.php|\.html|\.htm|\/)$ /?p=$1$2 [QSA,L]

I don't believe that's it because some of the RewriteRules higher on the list work correctly.

Okay, so both of the servers in question were runnig Apache/2.0.52 (CentOS). However, on one server my htaccess mod_rewrite syntax is working perfectly and on the other it's not working at all! Below is the syntax. RewriteEngine on RewriteRule ^print/$ /lib/cjprinterfriendlyv2/printpage.php RewriteRule ^make_offer/(\d+) /?action=make_offer&p=$1 [L] RewriteRule ^blog(/|)$ /?action=blog [L] RewriteRule ^blog/(.+)$ /?p=$1 [L] RewriteRule ^tags/(.+)$ /?tag=$1 [QSA,L] RewriteRule ^asset/(.+)/(\d+)(|/)$ /?asset=$1&id=$2 [L] RewriteRule ^video/(\d+)(|/)$ /?asset=video&id=$1 [L] RewriteRule ^asset/video/(.+)(\.php|\.html|\.htm)$ /?asset=video&file_name=$1 [L] RewriteRule ^video/(.+)(\.php|\.html|\.htm)$ /?asset=video&file_name=$1 [L] RewriteRule ^tags/$ /?tag=INDEX [L] RewriteRule ^presearch/$ /?action=presearch [QSA,L] RewriteRule ^search/(.*)/(|pages|images|videos)$ /?action=search&s=$1&t=$2 [L] RewriteRule ^sitemap/$ /?action=sitemap [L] RewriteRule ^sitemap/(image|video)(&p=(\d+)|)$ /?action=sitemap&m=$1&p=$3 [L] RewriteRule ^ecommerce-videos-movies/$ /?action=sitemap&m=video [L] RewriteRule ^ecommerce-images-photos/$ /?action=sitemap&m=image [L] RewriteRule ^email_this_page/(\d+)(|/)$ /?action=email_page&pid=$1 [L] RewriteRule ^email_this_page/asset/(\d+)(|/)$ /?action=email_page&&is_asset=true&aid=$1 [L] RewriteCond %{REQUEST_URI} !^/lib/ RewriteCond %{REQUEST_URI} !^/admin/ RewriteRule ^(.+)(\.php|\.html|\.htm|\/)$ /?p=$1$2 [QSA,L] For the newer server that's not doing what I expect my URLS http://www.domain.com/dynamic_page_title/ aren't working correctly. On my older server it worked perfectly. Any ideas?

Greetings, I've got several rules below. The problem is that even after it has applied one of the rules higher in the list it continues to apply the rules further down the list. What I'm looking for is for a rule to be applied and then for it to quit comparing the URL to the rules. RewriteEngine on RewriteRule ^print/$ /lib/cjprinterfriendlyv2/printpage.php Options FollowSymlinks RewriteRule ^make_offer/(\d+) /?action=make_offer&p=$1 RewriteRule ^blog(/|)$ /?action=blog RewriteRule ^blog/(.+)$ /?p=$1 RewriteRule ^tags/(.+)$ /?tag=$1 [QSA] RewriteRule ^asset/(.+)/(\d+)(|/)$ /?asset=$1&id=$2 RewriteRule ^video/(\d+)(|/)$ /?asset=video&id=$1 RewriteRule ^asset/video/(.+)(\.php|\.html|\.htm)$ /?asset=video&file_name=$1 RewriteRule ^video/(.+)(\.php|\.html|\.htm)$ /?asset=video&file_name=$1 RewriteRule ^tags/$ /?tag=INDEX RewriteRule ^presearch/$ /?action=presearch [QSA] RewriteRule ^search/(.*)/(|pages|images|videos)$ /?action=search&s=$1&t=$2 RewriteRule ^sitemap/$ /?action=sitemap RewriteRule ^sitemap/(image|video)(&p=(\d+)|)$ /?action=sitemap&m=$1&p=$3 RewriteRule ^ecommerce-videos-movies/$ /?action=sitemap&m=video RewriteRule ^ecommerce-images-photos/$ /?action=sitemap&m=image RewriteRule ^email_this_page/(\d+)(|/)$ /?action=email_page&pid=$1 RewriteRule ^email_this_page/asset/(\d+)(|/)$ /?action=email_page&&is_asset=true&aid=$1 RewriteRule ^(.+)(\.php|\.html|\.htm|\/)$ /?p=$1$2 [QSA] The last rule should only apply to queries NOT matching the rules above, sort of a catch all rule. How can I achieve this?

If you haven't fixed it yet you'll probably want to create a new style for the <li> elements as well so you have control over their padding/margin.

Okay, so this is a little difficult to explain.... I'm creating a PHP-powered AJAX interface that generates a list of items. What I'm wanting to do is make that list of items sortable so I'm using the scriptaculous Sortable.create method. Here's where it gets tricky. So my php file displays my result set using a Smarty template. The problem is that the smarty template (which contains the javascript that triggers the Sortable.create method doesn't appear to be included in the template when it's displayed, there's a blank spot in the source where the JS should be. Here's the JS that's at the bottom of my Smarty template: <script type="text/javascript"> {literal} <!-- Sortable.create("results_table", { onUpdate:function(){ alert(Sortable.sequence('results_table').join('')); } }); --> {/literal} </script> Any ideas?

Hey all, I'm using Prototype.js for some AJAX in a project. Typically I just call the PHP and use echo to return the real time results. However, I'm wanting to keep my code and design separate so I'm wondering what the best way to incorporate smarty templates into the mix is? Do I just use $smarty->fetch and echo that output? I haven't been able to get that to work yet. Below is my current code: if ($_GET["action"] == 'search') { $html = 'Yeah!'; $smarty->assign('html',$html); $results = $smarty->fetch('/admin/Templates/pages/related_search_results.html'); echo $results; exit; }

So I've got a data import script that can potentially run very long as it handles downloading of images via URLs as well as importing large amounts of data (15,000+ lines) from Excel. So what's the best way to make sure that the script actually runs to completion and doesn't time out? I've been using sleep() is that the best way?

Hey all, I'm currently using the simple PayPal Buy Now buttons on my site which directs the user to PayPal's shopping cart system (taking them away from my site). I'm looking to take my shopping cart to the next level of sophistication and I'm wondering if this exists: - A PayPal shopping cart API where PayPal still manages sessions, items in the cart, totals, etc - That can be accessed via PHP and we can control the design/layout of the pages completely - Then, at the end once the user is ready to checkout, PayPal also handles the payment for the cart total Could you all direct me in the right direction? I know PayPal has payment APIs but I'm hoping that they can continue to power my shopping cart while giving me the chance to keep visitors on my site and control the look of the cart.

Hey all, I'm looking for a high end, web-based database management package that has lots of nice features for sorting, searching, etc. This would be used by employees to manage a product database. Any recommendations?

I'm currently importing data into a database from an uploaded Excel file. Once the data has been imported I'm wanting to add a couple of columns to the Excel file to create a connection between the Excel file and our database. Can anyone tell me how it's possible for me to update the original Excel file with the new columns? I should mention that I'm currently using Spreadsheet_Excel_Reader (http://sourceforge.net/projects/phpexcelreader/) to import the Excel data currently.

The problem isn't that you need to put something around it, it's that your tag is empty and has no attributes. The <input> tag has necessary attribtues in order for it to be considered valid. More info here: http://www.w3schools.com/TAGS/tag_input.asp