Amazon products on Content Management Systems and PHP-MySQL

Tuesday, April 29, 2008

New or recent content not updated (and not searcheable) after publishing (drupal reindexing)

Perhaps the most basic questions asked by newbies might be on why after editing content, and after publishing, edited and recent contents are not updated. Or, why pages or stories are not searcheable after having been created or edited.

Recent versions of Drupal may not encounter these anymore, however just in case, this is simply a matter of reindexing your site. The ff. may be checked:

- within drupal's administer page: administer > search > reindex your site, or check desired / appropriate settings

- check out and download poormanscron module, a croning (reindexing) module for drupal with userfriendly settings page (administer > modules > poorman's cron)

- lastly, the fastest and most basic drupal re-indexing in the frontend (layman's: using the web browser directly): append to your site's url this... /cron.php (this will start the script in cron.php reloading the database content on the frontend)... e.g www.sitename/cron.php

Monday, April 21, 2008

Forgot your admin password in Drupal, Joomla, or any other php run cms with mysql database (with management in phpmyadmin)?

Forgot your password in Joomla, Drupal, or any other php run cms with mysql database (with management in phpmyadmin)?

In the event you forget your administrator password or passwords in in Joomla, Drupal, mediawiki, coppermine, etc. (or any opensource php-driven cms with mysql database manageable in phpmyadmin for that matter), a workaround is fortunately available. For newbies, forgetting one's administrator user account's password the only solution will have to be re-installing the entire cms from scratch thus re-creating an administrator account in the process. A solution is as follows:

- Go to site/phpmyadmin (login, of course assuming you have the necessary rights to the database/s)- Browse for the database, then the table (in the case of Joomla, Drupal, etc. this is commoonly the table 'users') intended to be edited

- click edit user, then under the 'Function' column (dropdown list) choose MD5, edit the 'Value' or your password (you will initially see the encrypted version of your original password), then type in the desired, new password of your choice

- Lastly, don't ever forget your password again, silly! :D

Thanks to pete avila and michael perido for the tip! cool guys from the pacific rim, philippines :p...

Wednesday, April 9, 2008

What is TCPDF - PDF class for PHP?

Below is a followup article to pdf module employed in drupal.

What is TCPDF - PDF class for PHP?

TCPDF is a PHP 5 class for generating PDF files on-the-fly without requiring external extensions. TCPDF is an extension and improvement of the FPDF class (www.fpdf.org). Supports UTF-8, Unicode, HTML and XHTML.

With regards to drupal it is a third party apps for php used in pdfview module which enables a pdf view or download as pdf option for nodes or pages. Simply extract the folder where the readme files instructs you to. Warning though, read a few forum on installation issues... reading the readme and install files thoroughly is a must! :D

Download TCPDF here:

for php 4:
http://sourceforge.net/project/showfiles.php?group_id=128076&package_id=140231&release_id=577068

for php5:
http://sourceforge.net/project/showfiles.php?group_id=128076&package_id=140403&release_id=577072

Drupal Products