Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Profile for MelsonMarketing

  • OFFLINE
  • Time Zone: GMT +0:00
  • Local Time: 23:27
  • Posts: 3
  • Profile Views: 1839
  • Location: Unknown
  • Gender: Unknown
  • Birthdate: Unknown
Posts

Posts

emo
I try to add a bookingoption "hourly" beside the existing "daily"

trying to save I see this error: 1054 Unknown column '1' in 'field list'

Does anyone know what this is?
1054 Unknown column ...
Category: Community Support
emo
I had the same problem.

But after changing the collations in the database all is working again.

It would be too hard to change all the tables manually - so use this script:

- Create a Php file with the following content and name it f.e. "change.php"
- Upload it via ftp to your Joomla-root
- Call it via your browser (www.yourdomain.com/change.php)
- Wait for success-message and you're done!

 
<?php
$conn1=new MySQLi("localhost","User","Passwort","Datenbank");
if($conn1->connect_errno){
echo mysqli_connect_error();
exit;
}
$res=$conn1->query("show tables") or die($conn1->error); while($tables=$res->fetch_array()){
$conn1->query("ALTER TABLE $tables[0] CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci") or die($conn1->error); } echo "The collation of your database has been successfully changed!";
 
$res->free();
$conn1->close();
 
?>
 


Regards

Michael
Does not work after ...
Category: Community Support
More
User Login Empty