Joomla SQL 2 Excel Replacement
Some months ago, almost a year I think there used to be a really ripping piece of software called SQL2Excel that was provided by Joomla R Us. It appears that this site has been down for a while, so I decided I would try to come up with a replacement that gets around some of the limitations.
So… It appears that I am not the only one who ran into this issue, and not actually having run into it directly myself, it was a little tricky to get to the root of the problem. In case you have no idea what I am talking about, I am talking about Miva Merchant and libGD configuration. Specifically when you upgrade Miva Merchant there can be an issue.
So, it appears that there are some subtle variants on the site hacked in google and returning viagara or cialus, however those are spelled. But I believe the attack vector is the same and the protection is the same.
NOTE: Do not do this on a live server, backup and test mileage before deploy as components and modules might not be available. Also templates need to be updated
It’s getting pretty easy to update things these days and Joomla is no exception. There is a component that you can get for the joomla 1.5 branch and later that is called jupdate. This component works pretty good as long as your permissions are set correctly. IE if you are not running as a specific user in php that has write permissions to the root of your site, then it may be a problem during the update phase.
Here and there I have come up with a problem to solve when either deploying word press sites or beginning to maintain sites that are live. My first step is usually to back up the site locally and attempt to fix the issues or create additional functionality as the situation calls for. The problem is that, the live site is usually not the same url that I am using. For instance, I can not use the same domain unless I want to continually be modifying my dns or hosts files. My solution is to usually have an automated way to create an aliasmatch such as the following: devsite.com/devhost where devhost is the domain. This is usually much different than livesite.com/blog or livesite.com.
Having trouble with letters missing from your pdf content when you copy it to web? I noticed this issue before which I at first thought to be a corrupted PDF, but the PDF itself retained the information.
So you want to allow SuperAdmin access to joomla for demos, but you don’t want anybody to be able to do anything? Well, if thats what you want to do, then you will have to perform the following.
In case anyone is wondering where they can get the latest version of Joomla information which is now scheduled to have a major release every 6 months, the url is http://update.joomla.org/core/list.xml. There is an extension update link as well but that does not seem to be filled in currently at: http://update.joomla.org/jed/list.xml. The latest release of Joomla is 1.7 as of the time of this posting.
If you have done some scripting with MooTools and Ajax you may find the following information useful. As it is, I could not find an easy way to detect when a user was logged out of Joomla in the administration control panel for an Ajax request.
Continue reading
Looking for a way to package a module inside a component package, I came across the following technique. Re-use the JInstaller class and the com_installer install from folder code as well as the unpack methods to unzip.
Continue reading
Was having an issue viewing some content on a Joomla 1.0 site. Noticed that the server code was php5.3. There are some issues with some versions of Joomla with php5.3. For the 1.5 branch, the latest versions work but the earlier ones do not as late as 1.5.14.
At any rate, without errors showing up it is often hard to find the solution without hacking core code. One such solution is to downgrade php which may be simple in a cgi environment.
Another possible solution was found at this blog posting.
The basic idea is to change the core Joomla 1.0 file includes/Cache/Lite/Function.php. By modifying the line that looks like:
$arguments = func_get_args();
with
$arguments = func_get_args();
$numargs = func_num_args();
for($i=1; $i < $numargs; $i++){
$arguments[$i] = &$arguments[$i];
}
The content becomes visible. There are other issues that could arise due to improper database content Finish Publishing Dates, and clearing the browser cache as well as site cache.
Update:
For those of you interested in converting Templates, Modules, Components, or Plugins from 1.0 to 1.5 – please check out this page
In case you are one of the select few who are having issues with the dreaded wp-admin login and clearing your cookies didn’t work. I would recommend reinstalling like several others, but is seems a tad overkill.
The key seems to be the details in the configuration that are hidden in the admin protected area such as siteurl. I was able to effectively break the login by adjusting 1 but not both of the admin settings when I moved my site from the test domain to the live. Upon using a database query I was able to rectify the offending database record in wp_options.
How to change CB Subs Paid Subscriptions content
CB Subs Paid Subscription content is a little bit difficult to find at first, but once you have found it a few times, it is easier to remember and edit.
Learn to post a video to a Social Engine Web site ( fishnlife.ca )
Posting to Social Engine/Fishnlife.ca with YouTube video is fairly straight forward as long as you know where to grab the url from.