I get an SQL ERROR / Warning as i try to update the student's information

[ronelgon]

Hello,
I get the an SQL Error /Warning below as i try to update a student's
information.

SQL/DB Error -- [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 'Mubs '', studentbio_fname=''Ronnie '',
studentbio_mi='', studentbio_generation='' at line 1]

Warning: Cannot modify header information - headers already sent by
(output started at /home/wauganet/public_html/sms/ez_sql.php:69) in /
home/wauganet/public_html/sms/admin_edit_student_4.php on line 161

Your help will be highly appreciated

Thanks

Ronnie

[Doug Poulin]

Sadly, about 2 days after posting version 1.09, I saw this error too.
I have the fix in the upcoming version 1.10, but I will create a quick fix and post it tonight.

Doug

--
You received this message because you are subscribed to the Google Groups "Swifttide" group.
To post to this group, send email to swif...@googlegroups.com.
To unsubscribe from this group, send email to swifttide+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/swifttide?hl=en.

[Doug Poulin]

Just posted swift109_patch_01.tar.gz

Just uncompress it, and insert these updated files into your webserver
swifttide installation directory. (The name of this directory will
vary based on what installation of webserver you are running, in
Apache it is often /var/www/html)

YOU MUST BE RUNNING AT LEAST PHP 4.3, as these fixes, along with the
next version of Commmand School, will utilize features in this and
more recent releases.

[ronelgon]

Hello,
I renamed the files and uploaded the files in a patch and now when i
try to login, i get the SQL/DB ERROR and warning message below;

SQL/DB Error -- [Unknown column 'carole' in 'where clause']

Warning: Cannot modify header information - headers already sent by

(output started at /home/wauganda/public_html/sms/ez_sql.php:69) in /
home/wauganda/public_html/sms/login.php on line 104

Warning: Unknown: Your script possibly relies on a session side-effect
which existed until PHP 4.2.3. Please be advised that the session
extension does not consider global variables as a source of data,
unless register_globals is enabled. You can disable this functionality
and this warning by setting session.bug_compat_42 or
session.bug_compat_warn to off, respectively. in Unknown on line 0

My server runs on

Apache version 2.2.14 (Unix)
PHP version 5.2.9
MySQL version 5.0.85-community

Your help will be highly appreciated.

Thanks

Ronnie

[Doug Poulin]

Unable to duplicate this issue. Please let me know if this is still
occurring.

[aadi]

i m getting this same problem 

thankz for this awesome php application ............

[Phemmy99]

Hi Doug,
I am also experiencing the same problem. There are two problems;
1) Saving a new contact user of student, when you click on set as user, the following error occurs;     
     SQL/DB Error -- [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 ' 'ayo', 'ade', ' ', 1)' at line 3]

SQL/DB Error -- [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 ' 102)' at line 1]

This also affects editing existing contact user record.

2) When you search for a student from manage student, it returns more than one record for that particular student, despite only one record of that student appear in the database. so from where did it get other displayed records?
Please i need your help and contributions.  Thanks