indexu 3.1 & mysql 3.22

[Heiko]

Hi again.


i found out, that indexu 3.1 doensn´t run with mysql 3.22.


any ideas ???



btw:


this is the problem part (table idx_link) with mysql 3.22

[.....]

keywords varchar(255) default NULL,

[....]

[COLOR=red] PRIMARY KEY (link_id),
[COLOR=red] KEY title (title,keywords) <-----------------------[COLOR=red] ??????
) TYPE=MyISAM;


[....]


mysql 3.22 doesn´t accept it.....


H E L P

[craven]

I'm having similar problems now with MySQL 3.22 trying to create tables through phpMyadmin and getting the following error message.


You have an error in your SQL syntax near '`idx_bad_link` (
`bad_link_id` mediumint(8) unsigned NOT NULL auto_increment,
' at line 12

Everytime I run install through Indexu it fails to create tables also. ANyone know what I'm doing wrong?

Thanks,

Craven

[Veg]

I had the same problem before but it works fine with MySQL Version 4.0.12

[Heiko]

Originally posted by Veg
I had the same problem before but it works fine with MySQL Version 4.0.12

yepp ..me....too...unfortunately only on my home-pc where i set up a local server with mysql 4.012

...so i have to ask my provider for a newer version...


bye
Heiko

[Veg]

Originally posted by Heiko



yepp ..me....too...unfortunately only on my home-pc where i set up a local server with mysql 4.012

...so i have to ask my provider for a newer version...
bye
Heiko

You web hosting provider is still using an old mysql version

Always update to the latest version otherwise your system can be compomised when it comes to security.

[sofiah]

The problem is in apostrophe in query. On queries defined in Indexu (because it used MySQL 4.0.2), each table name and field is using apostrophe. Example :

CREATE TABLE `idx_bad_link` (
  `bad_link_id` mediumint(8) unsigned NOT NULL auto_increment,
...... 

MySQL 3.x.x. and previous versions don't use aporstrophe, So the above query won't be recognize as a correct one. If you want to execute query in sql.txt, you need to remove those apostrophes. So the above query example will be :

CREATE TABLE idx_bad_link (
  bad_link_id mediumint(8) unsigned NOT NULL auto_increment,
...... 

Sofiah

[Heiko]

[QUOTE]Originally posted by sofiah
[B]The problem is in apostrophe in query. On queries defined in Indexu (because it used MySQL 4.0.2), each table name and field is using apostrophe. Example :

CREATE TABLE `idx_bad_link` (
  `bad_link_id` mediumint(8) unsigned NOT NULL auto_increment,
...... 

Hi Sofiah...thanks for the hints..

but i had done a global replace of the '`'-charakter...but...the problem with the idx_link table and the key(title,keyword) phrase still results in an error message
....in mysql 4.012 i only had to change the '`' after i went through it works....but unfortunately my 'f**g' provider' is running mysql 3.022

[Veg]

....in mysql 4.012 i only had to change the '`' after i went through it works....but unfortunately my 'f**g' provider' is running mysql 3.022 [/B]

Heiko, send me a pm and I will set-up an account for you on our web server so that you can create all the databases etc.

We will not charge you for it as it is a temporary account.

At least you should be able to use the database that you create on our web server even though your current provider are running an outdated mysql

[craven]

After 3 days I was told my host does not have any servers that that support MySQL 4.0.2.

Is there that big of difference between the versions?

Are there other problems that we'll run into using 3.22 with Indexu other than setup?

How about creating a file for those of us who are still using 3.22?

Thanks,

Craven

[Veg]

Originally posted by craven
After 3 days I was told my host does not have any servers that that support MySQL 4.0.2.

Is there that big of difference between the versions?

The reason why we web hosting companies always update the software, such as MySQL, is due to security measures and that the updated version are usually more fast and efficient.

Craven, I offered Heiko to create the databases on our web server to if it is possible to transfer them to his current web host.

Please send me a pm and I will extend the offer to you as well.

Good luck.

[dody]

Hi everyone, I use mysql 4.02, my webhost use MySQL 4.0.12. I do not know if indexu will make problem on older version.

PRIMARY KEY (link_id),
[COLOR=red] KEY title (title,keywords) <-----------------------[COLOR=red] ??????
[COLOR=red] ) TYPE=MyISAM;

PRIMARY KEY (link_id), :::: primary key, must have
KEY title (title,keywords) :::: index key, optional
) TYPE=MyISAM; :::: table type, optional

I though it's not problem if you're using v.3.22.xx because I'm not use the real power of v.4 that is 'transactional sql'. Let me see this further more.

[Veg]

I came across this in one of the forums

MySQL 4 comes with a fully ACID-compliant storage engine. ACID stands for Atomicity, Consistency, Isolation and Durability - features considered critical for data integrity. MySQL could never reliably be used for critical data transactions before this, and supplying this feature as a standard part of MySQL 4 takes care of one of the primary criticisms of the old versions.

MySQL originally gained popularity with website developers due to its speed in that kind of environment. The default, non-transactional MyISAM table types are extremely fast in a high-read, low-write environment, such as a website. And now MySQL 4's new query cache can double the speed of commonly-issued queries.

[craven]

Dody,

I've been trying for days to do the install and have tried several different things but still no luck! Have you figured out how to get 3.1 to work with MySQL 3.22? I'm hoping this is something simple and quick!

Thanks,

Craven

[Veg]

Originally posted by craven
Dody,
I'm hoping this is something simple and quick!

Thanks,

Craven

Craven, I offered Heiko to create the databases on our web server to see if it is possible to transfer them to his current web host, even though the mysql is old (very old).

Please send me a pm and I will set it up for you later on today.

The offer is obligation free and you do not need to host your site with us.

We are all part of the Indexu commuity and if we can help you out - then that's great.

[craven]

After more thought I decided I need to keep it all in one place and try to get things working! Thanks Anyways VEG!

Can you write a patch to fix this Dody? The script will run on MySQL 3.22 but it wont install correctly. Sofiah set up the tables for me on a test site and it worked great! But now I want to Install on my main site. There has to be a way to change the install process to allow for installation on older MySQL.

Thanks,

Craven