Self Service
Change My Password
Update My Info
ERROR reported by SQL_Query Subscriber ID: Descripition: Database access error Connection 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 'AND Pipeline_IsDefault_Std = TRUE' at line 1 SQL: SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = AND Pipeline_IsDefault_Std = TRUE Backtrace: 0> Utility_Database.php, line 144, ErrorMessage(SQL_Query, Database access 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 'AND Pipeline_IsDefault_Std = TRUE' at line 1, SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = AND Pipeline_IsDefault_Std = TRUE) 1> Utility_Database.php, line 123, SQL_Query(SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = AND Pipeline_IsDefault_Std = TRUE, ) 2> Utility_Database.php, line 189, ExecQuery(SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = AND Pipeline_IsDefault_Std = TRUE, ) 3> Menu.php, line 90, ExecQuerySingle(Pipelines, Pipeline_ID, WHERE Subscriber_ID = AND Pipeline_IsDefault_Std = TRUE) ERROR reported by SQL_Query Subscriber ID: Descripition: Database access error Connection 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 'ORDER BY Pipeline_ID DESC LIMIT 1' at line 1 SQL: SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = ORDER BY Pipeline_ID DESC LIMIT 1 Backtrace: 0> Utility_Database.php, line 144, ErrorMessage(SQL_Query, Database access 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 'ORDER BY Pipeline_ID DESC LIMIT 1' at line 1, SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = ORDER BY Pipeline_ID DESC LIMIT 1) 1> Utility_Database.php, line 123, SQL_Query(SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = ORDER BY Pipeline_ID DESC LIMIT 1, ) 2> Utility_Database.php, line 189, ExecQuery(SELECT Pipeline_ID FROM Pipelines WHERE Subscriber_ID = ORDER BY Pipeline_ID DESC LIMIT 1, ) 3> Menu.php, line 92, ExecQuerySingle(Pipelines, Pipeline_ID, WHERE Subscriber_ID = ORDER BY Pipeline_ID DESC LIMIT 1) ERROR reported by SQL_Query Subscriber ID: Descripition: Database access error Connection 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 'ORDER BY PipelineStage_Sequence' at line 8 SQL: SELECT PipelineStages.Stage_ID, PipelineStages.PipelineStage_Sequence, Stages.Stage_Name FROM PipelineStages LEFT JOIN Stages ON Stages.Stage_ID = PipelineStages.Stage_ID AND Stages.Stage_IsActive = TRUE WHERE Pipeline_ID = ORDER BY PipelineStage_Sequence Backtrace: 0> Utility_Database.php, line 144, ErrorMessage(SQL_Query, Database access 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 'ORDER BY PipelineStage_Sequence' at line 8, SELECT PipelineStages.Stage_ID, PipelineStages.PipelineStage_Sequence, Stages.Stage_Name FROM PipelineStages LEFT JOIN Stages ON Stages.Stage_ID = PipelineStages.Stage_ID AND Stages.Stage_IsActive = TRUE WHERE Pipeline_ID = ORDER BY PipelineStage_Sequence) 1> Menu.php, line 102, SQL_Query(SELECT PipelineStages.Stage_ID, PipelineStages.PipelineStage_Sequence, Stages.Stage_Name FROM PipelineStages LEFT JOIN Stages ON Stages.Stage_ID = PipelineStages.Stage_ID AND Stages.Stage_IsActive = TRUE WHERE Pipeline_ID = ORDER BY PipelineStage_Sequence)
Work Package Aging and Data Status
Common Tasks
Work Packages
Download Online Orders
Create Work Package
Create Child Work Package
Create Work Package (new ver)
Review POs
Drag 'n' Drop Part Images
Review Part Images
Ship (Stage) Orders
Export Jobs to .CSV
Export All Jobs to .CSV
Select Exported Columns
More Menus
Operations
Jobs by Status
Project Management
Directories
Materials and Stock Management
Lists
Process Design
Reports
Forensics
System Administration
Developer's Privileges
Operations
*Review New Online Orders
Create New Job
Add Work Package to job
*Manage Bills of Materials
*Manage Statements of Work
*Estimating
*Write POs
*Packing Lists
*Manage POs
*Receive Material
*Stage orders
*Edit A Job
*Edit A Work Package
*Find A Job
*Job Progress Chart
Close Submenu
Jobs by Status
*Stuck in a Stage
*On Hold
*Hold for Approvals
*Hold for Your Approval
Close Submenu
Project Management
Work Packages
Receive Online Orders
*Surveys
*Bills of Material
*Statements of Work
Dashboard
Close Submenu
Directories
Departments
Employees
Customers
Customer Reps
Contractors
Subcontractors
Vendors
Shippers
Permitting
Close Submenu
Materials and Stock Management
Materials and Inventory
Materials Options
Vendors' Products
Close Submenu
Lists
Shipping Methods
Skills
Invoice Terms
Bank Accounts
Mailing Lists
Document Types
Close Submenu
Process Design
Project Types
Fields
Blocks
Stages
Pipelines
Workflows
Field Pick Lists
Close Submenu
Reports
Part Quantities On Order
Work Package Aging
Open Jobs Belonging To Customer
Blocked Jobs with Open Purchase Orders
Lonnie's Unnamed Special Report
Recently Closed CENEX Jobs
Daily Data Entry Activity
Daily Work Package Position Changes
User's Work Package Position Changes
POs Report
Last 200 Closed Material/Labor Jobs
All GCI Jobs to .csv
All GCI Customers
WPs Ordering Selected Parts
WPs in Blocked With GCI Metal POs
Close Submenu
Forensics
Work Package Stage History
Work Package Field History
Workflow Exec Log
System Activity
Sessions History
System Audit
Deleted Work Packages
Close Submenu
System Administration
System Dashboard
Change User's Password
System Subscribers
User Accounts
Time Zones
Cellular Providers
Subcontractor Types
Run System Monitor
PO Sort Order
PO Pick List Sort Order
Online Order POs Tags
Hyperkeys
Hyperkeys Log
Backup Subscriber Data
Restore Subscriber Data
Close Submenu
Developer's Privileges
Manage Data Tables
Move WP to Other Job
Measurement Classes
Measurement Units
Import Online Inventory CSV
Import GCI Price List CSV
Manage workflow locks
Execute SQL
Special Page - Recover Deleted POs
Error Report Test
Reindex Field Data
Close Submenu
Proud Placeholder
Log Out