"Nickolas, thanks for the heads up. The component is not going to be distributed. I took the data out because it kept timing out, so it just creates the tables."
Ian O'Betz's Page
Latest Activity
Ian O'Betz replied to Ian O'Betz's discussion Size of SQL File for Component in the group DevelopersIan O'Betz replied to Ian O'Betz's discussion Size of SQL File for Component in the group Developers"Figured it out. Had to move the tags in the xml file to the tag."
Ian O'Betz replied to Ian O'Betz's discussion Size of SQL File for Component in the group Developers"The error is: Component Install: SQL error or missing or unreadable SQL file. DB function reports no errors"
Ian O'Betz added a discussion to the group Developers
Size of SQL File for Component
I've created a component but I'm having troubled with the installation of the component. I exported the 6 tables from mysql using phpMyAdmin. The XML file points to the right sql file, but I keep getting an error on import. The file imports properly through the command line, but not the installer. The file is 13MB. Is there a size limit on import?See More
Herman Peeren replied to Ian O'Betz's discussion Places for support in the group Developers"I don't think you posted the problem too early: there were some mistakes in the code from which we all could learn and also: it should run on your local machine too, not only online. So I would be curious if the component runs well on you local…"
Ian O'Betz replied to Ian O'Betz's discussion Places for support in the group Developers"It seems that I might have posted this problem a little early. I uploaded the component to a live/test site when active Joomla installs running and almost all of the problems cleared up. I am, however, getting one last problem:
When I call the…"
Herman Peeren replied to Ian O'Betz's discussion Places for support in the group Developers"Thank you very much for the code, but what is not clear to me now: is it working now? Did you send the code just to show how it looks now so we can give remarks for further improvement or is it to help debugging? And if there are still mistakes, are…"
Ian O'Betz replied to Ian O'Betz's discussion Places for support in the group Developers"Here is the code copied and pasted:
View.HTML.php:
class txViewfacility extends JView
{
function display($tpl = null)
{
$mainframe = JFactory::getApplication();
$document = JFactory::getDocument();
$data = $this->get('data');
$facility…"
Herman Peeren replied to Ian O'Betz's discussion Places for support in the group Developers"You twice use $this->data in your view where you should use $data.
So,
$data = $this->get('data');
if (!empty($this->data->first)) $first = $this->data->first[0];
if (!empty($this->data->radius)) $radius =…"
Ian O'Betz replied to Ian O'Betz's discussion Places for support in the group Developers"It seems whenever the first query returns successfully with at least 1 row, the second query returns null. When I switch the queries, dump the var and exit, the second query returns and the first one is null.
I then added another simple select *…"
Ian O'Betz replied to Ian O'Betz's discussion Places for support in the group Developers"Thank you for the response Herman. $this->_getList() seemed to work, although it did not fix the problem. I continue to get reference errors. I removed global mainframe and replaced it with a reference to getApplication, which worked as well. I…"
Herman Peeren replied to Ian O'Betz's discussion Places for support in the group Developers"Oops, just joined in again right now and see this discussion going out of hand... I haven't tested anything but after a quick glance I think you are now looking in a wrong direction. It is all much simpler.
I suspect the main mistake is in…"
Ian O'Betz replied to Ian O'Betz's discussion Places for support in the group Developers"Here are a couple of interesting tests that I've run: 3 queries in the model:
Query 1: Select one record based on $id
Query 2: Select multiple records based on $id and relating latitude/longitude
Query 3: Same as query 2, only inside stored…"
Ian O'Betz replied to Ian O'Betz's discussion Places for support in the group Developers"It could very well just be a problem on my local machine. Here is the information form joomla diags:
PHP Version 5.2.14
System Windows NT HOME 6.1 build 7600
Build Date Jul 21 2010 18:41:42
Configure Command cscript /nologo configure.js…"
Martin Blodau replied to Ian O'Betz's discussion Places for support in the group Developers"Ok sorry, i think my first suggestion was a bit hectic. Kid was screaming in the background while writing it. X-)
The error you get looks quite unusual and some Google research suggests that it's a bug that comes from the combination of a…"
Profile Information
- Business Web site
- http://www.clearresults.net
Comment Wall
- No comments yet!
© 2012 Created by Amy Stephen.
