mysql to mysqli

Project:RUetd
Version:2.3.1
Component:Code
Category:bug report
Priority:normal
Assigned:martyb
Status:closed
Description

Convert from using mysql functions to mysqli functions.

Comments

#1

Assigned to:chadmills» martyb
Status:active» test

#2

When testing this issue, check for the following, which caused this issue to be filed:

Marty was doing some testing on dev-etd following the SLES and PHP upgrade. When the home page was brought up, the following error was at the top of the page:

"Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /u2/htdocs/etd_dev/ruetd/library/database.php on line 21"

After login, when attempting to open some of the PDFs (previously and newly loaded), the following error was received:

"There was an error opening this document. The file is damaged and could not be repaired."

Some PDFs downloaded and opened successfully.

#3

Status:test» fixed

The noted errors no longer occur and other testing was successful. The dev-etd system with the SLES and PHP upgrades appears to work as expected.

#4

Status:fixed» closed

Applied to production at 7:14am on 5/16/2016.

log file of changes here:
@etd-prod/home/etddev/MYSQL_UPDATE_2.3.1

./content/profile.php
./content/school_embargoes.php
./content/create_account.php
./content/submission_reqs.php
./content/search.php
./content/programs_addedit.php
./content/change_pwd.php
./library/export_functions.php
./library/database.php
./library/functions.php
./process_steps.php

Back to top