Project

General

Profile

Actions

Anomalie #1136

closed

fix MySQL error when converting user

Added by Simon over 3 years ago. Updated over 3 years ago.

Status:
Fermé
Priority:
Normal
Assignee:
Category:
admin
Target version:
Start date:
05/08/2021
Due date:
% Done:

100%

Estimated time:
0.50 h
Resolution:

Description

[<em> error n° 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', rights_dashboard='U', rights_project='U', rights_publication='U', rights_works' at line 1</em> ]<br />

SQL query : UPDATE l21_rights SET , rights_dashboard='U', rights_project='U', rights_publication='U', rights_workshop='O', rights_news='O', rights_yellowpages='U', rights_level='U', rights_scale='U', rights_category_user='U' WHERE rights_id='5';

running script :/workshop/_user.php?action=changestatus&convert=O&id=5&u_id=5&mode=ajax

Actions

Also available in: Atom PDF