Home
Features
Download
Documentation
Forums
Screenshots
SVN & Bugtracker
Contact
New in 0.8.0
- Google analytics integration
- New user levels - Editor, Forum manager
- New component: Downloads
- HTML mailshots
- TinyMCE less bloat
- RSS feed autodiscovery
- Contact form - textarea
- Batch image upload with browser
- Navigation targets
- Gallery lightbox
- Extended user profile - MSN, skype, user bio
- Replace photo
- New theme 'Harmony’
- Many theme config items migrated to admin panel
|
Forums
| Author |
Post |
Tropy
Member
Germany
Posts: 26
|
I downled the newest Xampp package
and can`t install cause the sql syntax from SiteX and the syntax from the new mysql edition was diffrent
site x send:" Type=MyIsam "
Mysql need " Engine= Myisam " |
| philmills
Gold Team
Developer
Member
Site Admin
Tallinn, Estonia
Posts: 1,495
|
Thanks for the info on this.
It seems that because XAMPP is running MySQL 5.5 it doesn't accept "Type=" anymore. This is a change in MySQL 5.5. Most webhosting companies aren't yet running 5.5, as running the latest version always means problems like this for client websites. For the same reason SiteX needs to support older versions of MySQL, so we need to do some compatibility testing before upgrading SiteX installer so we can be sure that changing the install code won't affect installs on older MySQL versions.
If you want to run SiteX under Windows, I "usually" would recommend installing VertrigoServ (Apache, MySQL, PHP server bundle) rather than XAMPP. Its a dream to setup and administer, but I see also that the latest version of VertrigoServ runs MySQL 5.5... very annoying!
If you want to stay with XAMPP you'll have to simply edit setup/setup.php . Open it in Notepad++ or some similar text editor, and just find/replace all instances of Type=MyIsam with Engine=MyIsam. That should work - but make a backup copy first.
Another workaround may be to install SiteX on a server running MySQL 5.4, then expot the sql, then import it to your server.
Please let me know what happens, and I'll add this to the "Known Issues" section.
[Edited on 23/04/11 @ 6:46PM]
Fighting fires... and creating a few of my own...
|
| pelle
Member
Sweden
Posts: 17
|
Hi
I decided to try 0.8.0 today in my new server and also ended up with this MySQL 5.5 problem.
Even after replacing "TYPE = MYISAM" with "Engine = MYISAM" there is another problem during the installation. Next that comes is "BLOB/TEXT column 'bio' can't have a default value" and this goes for both MySQL 5.0 and 5.5.
After restarting the setup.php in my browser, without deleting the created tables, I can continue until my login credentials should be written to the database. Then this comes "Setup final step #2 : Table 'sm4xiu.sitex_users' doesn't exist"
What to do?
/Pelle
|
| Tropy
Member
Germany
Posts: 26
|
tried the same on xampp but no blob/text seen
dont know what the problem try to use an old xampp version install sitex an make an sql dump shuld work!"
by my self it works great!
hope could help you but the same answer as phmill above!
By tropy
|
| philmills
Gold Team
Developer
Member
Site Admin
Tallinn, Estonia
Posts: 1,495
|
How did you end up with a . in your database name? (sm4xiu.sitex_users)
I'm guessing that might cause a problem. I've never seen dots in database names before. Usually mysql will use an underscore _ as a seperator, not a dot.
If you're running XAMPP on Windows, please, please try VertrigoServ instead. Its sooooo much easier to setup, and works for me every time. If you run in on win 7 or 2008, make sure you run the app as admin.
Fighting fires... and creating a few of my own...
|
| pelle
Member
Sweden
Posts: 17
|
Don't know where the . came from :)
Now I had the time to dive into this problem with the setup.php script and got through the installation at last.
For those who end up in the same problem as I had with the 0.8.0 version then this info can be of value.
The TYPE= problem with MYSQL 5.0.5 is a bit tricky. Search & replace with exact match for "TYPE=M" and also for "TYPE = M" to be replaced with "ENGINE=M"
In addition to this I got the BLOB/TXT error message and I had to do the following changes to the script to make it pass through the installation:
Original:
`bio` mediumtext NOT NULL default '',
`avatar` varchar(255) NOT NULL default '',
`signature` mediumtext NOT NULL,
Changes:
`bio` mediumtext,
`avatar` varchar(255) NOT NULL default '',
`signature` mediumtext,
If this will have an impact on some functions I don't know yet. At least I am now installed and I have a working admin user immediately after installation with those changes of the script.
System:
Windows 2008 R2 64-bit
Apache 2.2.19 32-bit
PHP 5.2.17
MySQL 5.0.51a
Best,
Pelle |
| pelle
Member
Sweden
Posts: 17
|
Only one problem remains in the 0.8.0 beta and that is a error related to some of the check-boxes. Not all but a fewof them refuse to be blank.
Creation of photo albums. If I don't check the "Private" checkbox then I get this error:
SiteX experienced error #38 with an SQL bash readout of : Incorrect integer value: '' for column 'private' at row 1
I have the same problem when I should "Edit my profile"
If i don't check the "Show Email in Profile" i get the same type of error:
SiteX experienced error #98 with an SQL bash readout of : Incorrect integer value: '' for column 'showemail' at row 1
Else everything seems to work fine.
Please advice. Is this a simple bug where " " should be "0" as the default value in the database?
Best,
Pelle |
| pelle
Member
Sweden
Posts: 17
|
Hi again,
Solved the problem:
The problem had to do with how I had installed the My-SQL server. I choose to install it to be a "strict database server" which is not correct.
This is however easy to solve in the My-SQL config file my.ini
Original setting:
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
Replaced with :
sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
This will probably also solve the strange problems I had with Sitex v7 so now there is hope....
/Pelle
[Edited on 26/03/12 @ 7:16PM] |
|
|
If you're looking for...
fast setup, 10 languages, gallery with lightbox, forums, events, links, journal/blog, guestbook, polls, comments, contact form, HTML/plain text mailshots, downloads manager, easy page editing & creation, choice of designs, simple admin panel, user levels and much more
...you just found it!
Recent Forum Topics Recent Comments
|
