Hello Daniel and all!

We are having a bit of a problem installing the Bloggie... The component installs with all checkmarks showing it goes in ok, and we can see and look at the bloggie manager. On the Entries page for example we have the following error, line 344 in mysql.php. Further errors are for the reasons below the picture.

 

Upon looking at the database in PHPmyAdmin, we can see that the only table created by the installer is jos_bloggie_relations. We have tried a few times to uninstall after deleting this table, and reinstall, with the same results of a good component install, and a dropped sql install of only the relations table being created.

From all this, we can ascertain that the issue seams to be with the code in the install.php file, or some interpretation of it on our servers end, as it obviously starts the install, but silently drops during it, and continues on, installing the component correctly.

I have tried to do manual query runs, but it says there are errors in the code. as you are aware, PHPmyAdmin is not that great at error reporting in this situation, and I cannot say what is wrong with the code, and I don't have the expertice to go through it comparing what it wants(i don't know that) to what I have.

One solution I see is that you can post the install.php queries in their runable form, so we can manually add them. There are some good directions on this here from the guys making the Phoca Joomla! extension.

We are of course open to trying anything to solve this, as we feel your bloggie is the best available, and really want to use it.

 

Our configuration:
Joomla 1.5.14
PHP 5.2.12-pl0-gentoo
MySQL-Client-Version: 5.0.51
PhpMyAdmin - 2.11.5

Thanks from the Serving Audio team!!!

Kirk

Update - Anyone have a solution or the same problem? We really like the bloggie and want to get it installed.

 

I looked at the code and thought that it might be installing with the wrong character set. Maybe.

In the new release I'm dumping LyftenBloggie's built in Editor, I love it but it is too big, that will make the install file smaller so I can change around the install function some. I'll make it so that it will install with and without the character set utf8. Joomla is built to id which it needs during install.

As for now I made you a quick SQL file from my demo site. I removed the entries and left just the minimal stuff. it's attached to this post.

If your database prefix if different than "jos_" you will have to change that in the file.

-Daniel

Thanks Daniel!
Excellent! We really appreciate it, and I gave it a try:

But as you suspected, there is an issue with the CHARSET line 11
I keep getting I am not using the correct syntax, no matter how I configure that line.
The database was set up in default mode(not by me) in latin1.
I have tried to change the line to:
ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARACTER SET latin1;
or
ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARACTER SET `latin1`;
and both versions as utf8 as well.
Is there some way of writing this differently? it specifically says

#1064 - 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 'DEFAULT CHARACTER SET latin1' at line 11

it doesn't matter what I change the line to it has the same error... joomla installed correctly with sql lines like:
TYPE=MyISAM CHARACTER SET `utf8`;

I just don't know enough on sql coding relating to your program to change it..
any suggestions of code to try?

Sincerely,

The servingaudio.com Team

[Daniel Stainback 11 Mar 2010 14:20:26]

I looked at the code and thought that it might be installing with the wrong character set. Maybe.

In the new release I'm dumping LyftenBloggie's built in Editor, I love it but it is too big, that will make the install file smaller so I can change around the install function some. I'll make it so that it will install with and without the character set utf8. Joomla is built to id which it needs during install.

As for now I made you a quick SQL file from my demo site. I removed the entries and left just the minimal stuff. it's attached to this post.

If your database prefix if different than "jos_" you will have to change that in the file.

-Daniel

I believe it would be:

ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;