mwasif
Joined: Jul 3 '06
Location: Pakistan
-
Percona provides professional services to restore database, free services won't be possible. -
Use MySQL's DATE_FORMAT() to output in the format you like.Leave a comment:
-
DB access is denied to MySQL user. Use the correct credentials.Code:Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 807.
Leave a comment:
-
2MB limitation seems to be of PHP (phpMyAdmin). You can increase upload limit in PHP by changing values of upload_max_file size and post_max_size. Or you can use MySQL command line client to import CSV file.Leave a comment:
-
In the above SQL examples you are saving images on disk and saving the path in DB. Follow this example to store images in DB.Leave a comment:
-
Use LOAD DATA INFILE to import the contents of file to a table and then update the respective table with a JOIN.Leave a comment:
-
You should create a separate table to store images/images path containing the following 2 fields (you can add more fields if required e.g. image type) e.g.
vehicleId
imagePathLeave a comment:
-
It looks like you are using case sensitive collation. Provide the output of the following query so that we can suggest you something
[CODE=mysql]DESC crediteuren;[/CODE]Leave a comment:
-
Is max_allowed_pac ket=16M written under [mysqld] in my.cnf?
Run the following command on mysql prompt and post the out put here
[CODE=mysql]SHOW VARIABLES LIKE 'max_allowed_pa cket';[/CODE]Leave a comment:
-
Can you provide plain query instead of PHP code?
This query will not return desired results if there is a comma in $id. To workaround this you can try thisCode:SELECT * FROM table_name WHERE FIND_IN_SET('$id',`allgenreid`)
Code:SELECT * FROM table_name WHERE FIND_IN_SET('5',`allgenreid`) AND FIND_IN_SET('7',`allgenreid`)Leave a comment:
-
You can use LOAD DATA INFILE from command line or other import options in phpMyAdmin (just go to import option in phpMyAdmin).Leave a comment:
-
Run this query in MySQL and post the results here
[CODE=mysql]SHOW GRANTS FOR 'cars2'@'VWEB2' ;[/CODE]
Did you specify the same server name for Magento in mysql_connect() ?Leave a comment:
-
User cars2 does not have privileges to connect to the database from server VWEB2.Leave a comment:
-
Use GROUP_CONCAT().Leave a comment:
-
Run an EXPLAIN and post the output here.Leave a comment:
-
You need to allow your MySQL user to connect remotely using GRANT. Some hosting providers do not allow to remote connections.Leave a comment:
-
It should work. Try CONCAT_WS() instead of CONCAT().
Code:SELECT CONCAT(' ', `city`, 'text') FROM tableLeave a comment:
No activity results to display
Leave a comment: