lwtproject Pentaglot Senior Member Netherlands https://learning-wit Joined 4893 days ago 149 posts - 264 votes Speaks: French, Dutch*, German, English, Mandarin Studies: Italian
| Message 33 of 355 12 July 2011 at 2:27pm | IP Logged |
tommus wrote:
Invalid query: select StValue as value from settings where StKey = 'currentlanguage'
|
|
|
Seems your database is created with an old installation before 0.6.
Settings were introduced in 0.6
to fix this, import: dbupgrade.0.5.sql
------------------
USE `learning-with-texts`;
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
`StKey` varchar(40) NOT NULL,
`StValue` varchar(40) DEFAULT NULL,
PRIMARY KEY (`StKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `settings` VALUES ('currentlanguage', '1');
INSERT INTO `settings` VALUES ('currenttext', '1');
-------------------------
This is still a BETA application, please don't do productive stuff with it...
2 persons have voted this message useful
|
Michel1020 Tetraglot Senior Member Belgium Joined 5018 days ago 365 posts - 559 votes Speaks: French*, English, Spanish, Dutch
| Message 34 of 355 12 July 2011 at 4:52pm | IP Logged |
lwtproject wrote:
I can only give support for XAMPP and MAMP local web servers.
Please use XAMPP and use the current version of LWT (0.8.1).
|
|
|
What are the minimal requirements of apache php and mysql, what module are required what is your php info ?
The best way so far to avoid trouble with à is to put it in (à) or followed by a slash à/
1 person has voted this message useful
|
lwtproject Pentaglot Senior Member Netherlands https://learning-wit Joined 4893 days ago 149 posts - 264 votes Speaks: French, Dutch*, German, English, Mandarin Studies: Italian
| Message 35 of 355 12 July 2011 at 10:46pm | IP Logged |
@Michel1020
I just tried EasyPHP on WinXP.
Downloaded it and installed it.
Copied the LWT zip content to C:\Programs\EasyPHP-5.3.6.0\www\lwt
Changed the file connect.inc.php to:
-------------
$server = "127.0.0.1";
$userid = "root";
$passwd = "";
$dbname = "learning-with-texts";
-------------
Started phpMyAdmin via http://127.0.0.1:8888/home/mysql/
Imported dbinstall.sql successfully
Started LWT: http://127.0.0.1:8888/lwt
Everything works fine.
With the default French language settings, French texts like from lefigaro.fr website can be easily stored
(copy&paste)
and used for learning.
See screenshot: http://imageshack.us/photo/my-images/62/screenshotans.jpg/
No à-Problems or other problems at all. I use Firefox. IE8 will not work. IE9 maybe, but not installable under XP.
Sorry, but I really don't understand your problems.
Edited by lwtproject on 12 July 2011 at 10:53pm
1 person has voted this message useful
|
tommus Senior Member CanadaRegistered users can see my Skype Name Joined 5867 days ago 979 posts - 1688 votes Speaks: English* Studies: Dutch, French, Esperanto, German, Spanish
| Message 36 of 355 12 July 2011 at 11:51pm | IP Logged |
lwtproject wrote:
Seems your database is created with an old installation before 0.6.
Settings were introduced in 0.6
to fix this, import: dbupgrade.0.5.sql |
|
|
I started with 0.6 and never used an earlier version.
That import fixed most things. Everything seems to be there. However, in My Texts and My Terms, the dropdown menu for Filter Language is fixed on French. Even though it shows all the other 4 languages plus filter off, it goes back to French no matter what you select. So I cannot get to anything but French. My Languages and My Statistics show all five language and the correct details.
1 person has voted this message useful
|
tommus Senior Member CanadaRegistered users can see my Skype Name Joined 5867 days ago 979 posts - 1688 votes Speaks: English* Studies: Dutch, French, Esperanto, German, Spanish
| Message 37 of 355 13 July 2011 at 12:21am | IP Logged |
It looks like IMPORTING dbupgrade.0.5.sql hardwired the Language to French (1) as in the last two lines of that file.
INSERT INTO `settings` VALUES ('currentlanguage', '1');
INSERT INTO `settings` VALUES ('currenttext', '1');
So I changed that file to:
INSERT INTO `settings` VALUES ('currentlanguage', '5');
INSERT INTO `settings` VALUES ('currenttext', '5');
So it is now hardwired to Dutch, but at least I have my Dutch texts and words back.
How do I get to the state where I can select the languages again?
Thanks.
1 person has voted this message useful
|
redmor Trilingual Pentaglot Newbie MoroccoRegistered users can see my Skype Name Joined 5813 days ago 14 posts - 17 votes Speaks: Arabic (Written)*, Arabic (classical)*, Arabic (Maghribi)*, Spanish, French Studies: English, Portuguese
| Message 38 of 355 13 July 2011 at 2:07am | IP Logged |
Hi friend waaw thx a lot,I did all the steps and it works fine in win7 it's really very helpful, thx for make it an open source.
1 person has voted this message useful
|
lwtproject Pentaglot Senior Member Netherlands https://learning-wit Joined 4893 days ago 149 posts - 264 votes Speaks: French, Dutch*, German, English, Mandarin Studies: Italian
| Message 39 of 355 13 July 2011 at 9:08am | IP Logged |
tommus wrote:
I started with 0.6 and never used an earlier version.
That import fixed most things. Everything seems to be there. However, in My Texts and My Terms, the dropdown
menu for Filter Language is fixed on French. Even though it shows all the other 4 languages plus filter off, it goes
back to French no matter what you select. So I cannot get to anything but French. My Languages and My Statistics
show all five language and the correct details.
|
|
|
It seems your 0.6 version is broken somehow. I would download 0.6 again, and install it (without media and
connect.inc.php). If the database is really created with 0.6 - it should then run properly.
But it would be MUCH BETTER to start from scratch and install 0.8.1 and import your words and texts again.
Please understand that this software is still BETA, and LWT is not created by a group of professional software
developers. It's a hobby project and I am the only one ;-)
In the next weeks there are only a few things to be done (new tests, some improvements, some documentation,
and of course bug fixing), then version 1.0 will be released.
1 person has voted this message useful
|
tommus Senior Member CanadaRegistered users can see my Skype Name Joined 5867 days ago 979 posts - 1688 votes Speaks: English* Studies: Dutch, French, Esperanto, German, Spanish
| Message 40 of 355 13 July 2011 at 1:51pm | IP Logged |
lwtproject wrote:
But it would be MUCH BETTER to start from scratch and install 0.8.1 and import your words and texts again.
Please understand that this software is still BETA, and LWT is not created by a group of professional software developers. It's a hobby project and I am the only one ;-) |
|
|
My version 0.6 is working perfectly. Version 0.8.1 is working perfectly except that I can't change languages. So I am going to keep 0.6 for now and do a completely fresh install with 1.0 when it becomes available.
I fully understand that the software is still BETA. I'm just trying to contribute to what I believe is a wonderful product. The more I use it, the better I like it. It is so easy and fast to use, and has wonderful features. It is amazing that you have made such a complex application so easy to use.
1 person has voted this message useful
|