• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Editing Database Manually

Editing Database Manually 17 years 2 months ago #1866

Hi,

I've encountered a problem when I edited one of the submitted forms I received manually in the database via phpmyadmin. After I altered the values of the submitted form under the params field, all the data for that particular entry returns as one chunk of code in a cell including the CSV separator '||' in the task=listdata page, instead of being separated to their corresponding cells.

I'm guessing it has something to do with the newline or *slash*n code?

Any tip on getting the data back sitting on their corresponding cells?<br><br>Post edited by: whiterabbit, at: 2008/02/10 21:07
The administrator has disabled public write access.

Re:Editing Database Manually 17 years 2 months ago #1867

The administrator has disabled public write access.

Re:Editing Database Manually 17 years 2 months ago #1874

I have found out the culprit. It's the carriage return \r.

What I did was to export my forms and when I took a look at the data, I saw \r in between || and \n.
Info1=abc||\r\ninfo2=def||\r\ninfo3...

I removed \r and saved the text file and tried to restore the form. Instead of working, I got another error while processing:

\"Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /usr/local/tmp/phpwJIAbn on line 6\"

Now what? Anyone can shed me some light?

Post edited by: whiterabbit, at: 2008/02/11 15:57<br><br>Post edited by: whiterabbit, at: 2008/02/11 15:58
The administrator has disabled public write access.

Re:Editing Database Manually 16 years 10 months ago #3444

I'm getting the same error.

Did you get an answer or solution?

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!